What are the different ways of moving data between databases in SQL Server

Q

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

✍: Guest

A

There are lots of option available; you have to choose your option depending upon your requirements. Some of the options you have are: BACKUP/RESTORE, detaching and attaching databases, replication, DTS, BCP, logshipping, INSERT...SELECT, SELECT...INTO, creating INSERT scripts to generate data.

2007-10-25, 4505👍, 0💬