MDriven Server stores the application's data in the database set for the model slot A0. A new MDriven Server starts with a small built-in database. To store the data in SQL Server (on your own server or in Azure) instead, do this:

1. Log in to your MDriven Server (for example yoursite/__MDrivenServer). For sites hosted through the MDriven Portal, the credentials are in portal.mdriven.net; for your own installation, use your administrator account.
2. Go to AdminArea / Model Version Administration
3. Select A0
4. Pause your App with the Pause button
5. Change ConnectionType to SqlServer
6. Paste in ConnectionString that includes the user and password
7. Start your app

This makes your app use SQL Server instead of the built-in database. But the SQL Server database is still empty – MDriven must create the schema.

To make MDriven create the schema, do this. Only do this for a new, empty database – take a backup first if there is anything you want to keep:

1. Make sure you have the model locally in MDrivenDesigner
2. Delete ALL VERSIONS of the model in MDriven Server so that the list is empty and contains NO MODELS
3. Upload the model from MDrivenDesigner
4. MDriven Server will now find that there is no old model to evolve and will create the database as a result

Automating it: the MDriven Installation Scripts write the A0 connection string into MDriven Server when they install it. For PostgreSQL and MySQL, see Production databases.