What are the different ways of moving data/databases between servers and databases in SQL Server? | Data Mining Interview Questions

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.