Forum guidelines
AuthorQuestion
Moving data in Sql Server
Posted By Arjun Panwar on 14 Dec 2011
HI,

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


Thanks

AuthorReply
Re: Moving data in Sql Server
Posted By Priya Linge on 15 Dec 2011  
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.

Re: Moving data in Sql Server
Posted By Satyapriya Nayak on 15 Dec 2011  
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

If this post helps you mark it as answer
Thanks

Re: Moving data in Sql Server
Posted By Arjun Panwar on 15 Dec 2011  
Thanks to all

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.