Create MS SQL database
Navigate to: Main Menu > MS SQL > Click (+) Create database (or select the icon on an available package).
This form initializes a new, empty MS SQL database container. Once created, you can deploy your schema and data into it.
Configuration Fields
- MS SQL plan: Select the active subscription you wish to use for this database.
- Database name: Enter a unique name for your database. This will identify it in connection strings.
- MS SQL Login: Select the administrative user (Database Owner / DBO) for this database. You can choose an existing login from the list or select the option to generate a new one.
- MS SQL Server version: Choose the database engine version.
Critical Warning: MS SQL versions are not backward compatible. If you select a version (e.g., 2019) that is newer than what you use on your local computer (e.g., 2014), you will not be able to download a backup and restore it locally later without upgrading your local software.
Finalizing Setup
Click CREATE DATABASE to begin provisioning.
Connection Delay: The system creates a unique DNS address for your database. While creation is instant, global DNS propagation may take up to 30 minutes. During this time, you might not be able to connect to the database from your local computer.