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 is PROJECTION Operation?

1022

What is raiseerror? What is raiseerror?

1141

What are page splits? : SQL Server Architecture

989

Explain the difference between clustered and non-clustered index?

923

Which is faster statement or preparedstatement?

945

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1066

What is t-sql script to take database offline – take database online.

1087

Explain transaction server explicit transaction?

932

When a primary key constraint is included in a table, what other constraints does this imply?

989

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1044

Why functions are used in sql server?

962

Can two tables have the same primary key?

1208

How sql server executes a statement with nested subqueries?

1030

What is recompile sql server?

1040

What is onf in normalization form?

1056