1.

What Are The Different Ways Of Moving Data/databases Between Servers And Databases In Sql Server?

Answer»

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.

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.


Discussion

No Comment Found

Related InterviewSolutions