Servers and Databases in SQL Server

Question

Hi Ques What are the different ways of moving data between servers and databases in SQL Server ?

Senthilkumar · Answer

Hi Please refer this microsoft tutorial for detailed description. http://support.microsoft.com/kb/314546

Satyapriya Nayak · Answer

Hi Arun There are several ways of doing this. One can use any of the following options: - BACKUP/RESTORE - Dettaching/attaching databases - Replication - DTS - BCP - logshipping - INSERT...SELECT - SELECT...INTO - creating INSERT scripts to generate data. Thanks