Copying a database to an offsite location

The situation

You have a new offsite location, and you need to deploy your database to the new site. The database is large, so migration is not straightforward.

Key challenges

• Minimizing the time to deploy the database.

How we can solve it

1. Use SQL Packager to package the database into a .NET executable.
   1. Select the objects and data that you want to be deployed.
   2. Preview the SQL code that will be used to create the schema and data.
   3. Generate the package using compression.
2. Run the package on the destination server.

Benefits of our solution

• SQL Packager can be run on the database while it is live, so there is no impact on users.
• Compressing the package reduces transfer and upload times.
• No expertise in SQL is required to run the .NET executable and install the database.
• The package can be used again and again, if necessary.

Support & documentation

• Worked example: Packaging a database as a .NET executable