What should we do to copy the tables, schema and views from
one SQL Server to another?

Answers were Sorted based on User's Feedback



What should we do to copy the tables, schema and views from one SQL Server to another?..

Answer / kmbkrishnan

Copy Database wizard is one of the option to copy a
Database to another Database.

Is This Answer Correct ?    4 Yes 0 No

What should we do to copy the tables, schema and views from one SQL Server to another?..

Answer / guest

We have to write some DTS packages for it.

Is This Answer Correct ?    2 Yes 0 No

What should we do to copy the tables, schema and views from one SQL Server to another?..

Answer / guest

We have to write some DTS packages for it.
Copy Database wizard is one of the option to copy a
Database to another Database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the advantages of log shipping?

0 Answers  


Where is my database stored on the hard disk in ms sql server?

0 Answers  


where the connection string store in the database

0 Answers   HCL, Wipro,


Can we use custom code in ssrs?

0 Answers  


What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,






Why are you getting errors when creating a new odbc dsn?

0 Answers  


What are the four main query statements?

7 Answers   Wipro,


What stored by the master?

0 Answers  


Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,


What do you understand by triggers and mention the different types of it?

0 Answers  


How to display a past time in days, hours and minutes?

0 Answers  


What is change tracking in sql server?

0 Answers  


Categories