Skip to content

Categories:

Moving an MS SQL Server database from one server to another

This post is for:

  • Publishing an SQL Server database (including DDL and data)to another server
  • Moving / publishing a database to a shared hosting service (such as GoDaddy) when that service does not allow you to restore a database that was not backed up using their systems.

Creating the scripts

  1. Download the SQL Server Database Publishing Wizard from one of these URLs
    • http://sqlhost.codeplex.com/Wiki/View.aspx?title=Database%20Publishing%20Wizard
    • http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A
  2. Install on the source server
  3. Run the GUI and follow the wizard.

Installing the scripts

You can either run the scripts on the target server manually, or use the Database Publising Wizard to do this for you.

Posted in Uncategorized.

Tagged with .