SQL Server DTS- August 29, 2008 at 18:00 PM by Amit Satpute
What are the different ways of moving data/databases between servers and
databases in SQL Server?
There are several ways of doing this. One can use any of the following options:
- BACKUP/RESTORE,
- Dettaching/attaching databases,
- Replication,
- DTS,
- BCP,
- logshipping,
- INSERT...SELECT,
- SELECT...INTO,
- creating INSERT scripts to generate data.
|