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

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


Thanks
Reply Quick Reply Report a Spam

Our Recommended Solutions

[ + ]
AuthorReply
Priya Linge
  • 0
  • 0
Re: Moving data in Sql Server
Posted 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.
Reply Quick Reply
Satyapriya Nayak
  • 0
  • 0
Re: Moving data in Sql Server
Posted 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
Reply Quick Reply
Arjun Panwar
  • 0
  • 0
Re: Moving data in Sql Server
Posted on: 15 Dec 2011  
Thanks to all
Reply Quick Reply

SEARCH ANSWERS

Join a Chapter
Our recommended forum posts
HOT QUESTIONS
SPONSORED BY
  • PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.
Get Career Advice from Experts
Hosted By CBeyond Cloud Services TOP MEMBERSMOST VIEWEDLEGENDSNOW PRIZES
PHOTOSTIPSCONSULTING TRAINING STUDENTSMEMBERSMEDIA KIT SUGGEST AN IDEA
PRIVACY POLICY | TERMS & CONDITIONS | SITEMAP | CONTACT US | ABOUT US | REPORT ABUSE
2013© C# Corner. All contents are copyright of their authors.