Last Updated: Aug 29,2010
What are the different ways of moving data/databases between servers
and databases in SQL Server?
That's a bit out of scope for "Android News & Talk", but what the heck. For starters, do you wish to move the whole database to a new server? For that, just export the database from your current server. If it's large, be sure to zip it, as the native SQL Server export does 0 compression. Move it to the new server and restore the database as described here:
How to: Restore a Database Backup (SQL Server Management Studio)
If you are just moving tables, or subsets of tables and you need to renumber keys, that is a more involved discussion.
Separate names with a comma.