We have to write some DTS packages for it. Copy Database wizard is one of

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

Question Posted / guest

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

997

What is named query? : sql server analysis services, ssas

956

What is #table in sql server?

1037

What is Lock table in SQL?

1459

what is a transaction? : Sql server database administration

987

What is the difference between sdf and mdf?

1296

What is difference between group by and having?

941

List out different types of normalizations in sql server and explain each of them?

918

What do you think of this implementation? Can this be implemented better?

929

What are the differences between triggers and stored procedures?

1059

What is raid and what are different types of raid levels?

1138

Please explain what is “asynchronous” communication in sql server service broker?

929

What are the advantages of sql azure?

140

How to rebuild indexes with alter index ... Rebuild?

1116

What are subqueries in sql server?

1116