1. Check out our companion app, Forums for Android! Download from Google Play

databases in SQL Server

Discussion in 'Android Lounge' started by ali0482, Aug 28, 2010.

  1. ali0482

    ali0482 New Member
    Thread Starter
    5

    Aug 28, 2010
    1
    0
    5
    What are the different ways of moving data/databases between servers
    and databases in SQL Server?
     

    Advertisement

  2. fredsmith

    fredsmith Well-Known Member
    18

    Jun 13, 2010
    86
    13
    18
    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...