Moving data in Sql Server

Question

HI What are the different ways of moving data/databases between servers and databases in SQL Server? Thanks

Arjun Panwar · Answer

Thanks to all

Satyapriya Nayak · Answer

Hi Arjun There are several ways of doing - BACKUP/RESTORE - Dettaching/attaching databases - Replication - DTS - BCP - logshipping - INSERT...SELECT - SELECT...INTO - creating INSERT scripts to generate data. Thanks

Priya Linge · Answer

Hi 1.BACKUP/RESTORE dettaching and attaching databases replication DTS BCP logshipping INSERT...SELECT SELECT...INTO creating INSERT scripts to generate data. Please check below link for more inforamtion. http://www.windowsitpro.com/article/john-savills-windows-faqs/how-do-i-transfer-data-between-sql-server-databases-across-servers - Hope this will help you. Thanks.