1. Download our Official Android App: Forums for Android!

databases in SQL Server

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

  1. ali0482

    ali0482 Lurker
    Thread Starter
    Rank:
    None
    Points:
    5
    Posts:
    1
    Joined:
    Aug 28, 2010

    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
    Rank:
    None
    Points:
    18
    Posts:
    86
    Joined:
    Jun 13, 2010

    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...