databases in SQL Server


Last Updated:

  1. ali0482

    ali0482 New Member This Topic's Starter

    Joined:
    Aug 28, 2010
    Messages:
    1
    Likes Received:
    0
    What are the different ways of moving data/databases between servers
    and databases in SQL Server?
     

    Advertisement
  2. fredsmith

    fredsmith Well-Known Member

    Joined:
    Jun 13, 2010
    Messages:
    86
    Likes Received:
    13
    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.
     

Share This Page

Loading...