Deploy MS SQL database
Deploying an MS SQL database can be a complex process, but our control panel offers several streamlined methods to get your data online easily.
Prerequisites
- Create an Empty Database: Before you can deploy your data, you must first create an empty database container within the control panel. See instructions on how to create a database.
- Instance Warning: Full "Instantiated" MS SQL database migrations are not supported directly. However, if you have data from a specific instance, you can still use it by utilizing the Attach method described below.
Deployment Methods
Once your empty database is created, you have three options for deploying your data, depending on what files you have available:
- Run SQL Scripts:
- If you have a generated SQL deployment script (often created via SQL Management Studio), you can upload and execute it using the Run scripts tool.
- Restore from Backup (.bak):
- If you have a standard full backup file from your development server, you can upload it and use the Restore tool.
- Attach Database Files (.mdf/.ldf):
- If you have the raw data and log files, you can upload them and use the Attach tool.
Next Steps
After your database is successfully deployed, remember to update the connection settings in your application's configuration to point to the new server.