Use SqlServer

To switch your Tunrkey site from using the default SQLCompact to use SQLServer in Azure instead you go like this:

  1. Login to you MDrivenServer (yoursite/__MDrivenServer - credetials in portal.MDriven.net )
  2. Go to AdminArea / Model Version Administration
  3. Select A0
  4. Pause your App with Pause button
  5. Change ConnectionType to SqlServer
  6. Paste in ConnectionString that includes user and pwd
  7. Start your app
2017-02-25 13h18 19.png

This will make your app look in the SQLServer instead of the default CompactDB

But your SQLServer is still empty! MDriven must create the schema.

To signal MDriven to drop everything and re create the schema you go like this:

  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 it will recreate the database as a result
This page was edited 47 days ago on 02/10/2024. What links here