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 happens when converting big values to numeric data types?

1226

What are temporal tables in sql server 2016?

929

What is rs.exe utility?

164

How sql server enhances scalability of the database system?

1315

how many triggers you can have on a table? : Sql server database administration

1017

What is the difference between char and varchar2 datatype in sql?

1121

Tell me extended events in sql server 2008?

1053

How to create and drop temp table in sql server?

1100

List out the differences between global and local temp tables in sql server?

1109

What is pivot and unpivot?

1065

What are binary string data types in ms sql server?

1390

Which table keeps information about stored procedures?

983

How do you run a trace?

946

What is the report model project?

151

Explain the commands in sql server?

1096