Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

How to copy the tables, schema and views from one SQL Server to another?

Add comment
Views: 125
Votes: 0
Comments: 0
There are multiple ways to do this.

“Detach Database” from one server and “Attach Database” to another server.
Manually script all the objects using SSMS and run the script on new server.
Use Wizard of SSMS.
Others in this Category
document What is Identity?
document How to rebuild Master Databse?
document What is Policy Management?
document What is NOT NULL Constraint?
document What is Normalization?
document What is SQL Profiler?
document What is De-normalization?
document What is Log Shipping?
document Q: What are the Various Master and Detail Relation ships.
document What is Data Compression?
» More articles



RSS