1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

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

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

What command is used to create a database in the sql server and how?

0 Answers  

What is use of @@ spid in sql server?

0 Answers  

what is difference between nchar and char in Sql server ?

3 Answers  

What is page in sql server?

0 Answers  




I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

What is difference between foreign key and unique key?

0 Answers  

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

How to get all stored procedures in sql server?

0 Answers  

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

What is the most common type of join?

0 Answers  

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

For more SQL Server Interview Questions Click Here
Categories