4. How to copy the tables, schema and views from one SQL Server to another?

How to copy the tables, schema and views from one SQL Server to another?

Answer

There are multiple ways to do this.
1)“Detach Database” from one server and “Attach Database” to another server.
2)Manually script all the objects using SSMS and run the script on new server.
3)Use Wizard of SSMS.

All sql Questions
Ask your interview questions on sql

Write Your comment or Questions if you want the answers on sql from sql Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---