Different ways of moving data/databases between servers and databases

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.
How DTS is used to extract, transform and consolidate data
Data Transformation Services is a set of tools available in SQL server that helps to extract, transform and consolidate data.......
What is built-in function? Explain its type i.e. Rowset, Aggregate and scalar
A built in function of sql is used for performing calculations. These are standard functions provided by sql......
What are the benefits of User-Defined Functions?
User defined functions are created and defined by the user. They are created as per users needs.........
Post your comment