Moving data in Sql Server

Thanks to all

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

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.