Documentation:Use SqlServer: Difference between revisions

Use SqlServer

Latest revision as of 06:24, 20 January 2025

This page was created by Hans.karlsen@mdriven.net on 2017-02-25. Last edited by Edgar on 2025-01-20.

To switch your Turnkey site from using the default SQLCompact to using the SQLServer in Azure instead, do this:

Login to you MDrivenServer (yoursite/__MDrivenServer - credentials in portal.MDriven.net)
Go to AdminArea / Model Version Administration
Select A0
Pause your App with the Pause button
Change ConnectionType to SqlServer
Paste in ConnectionString that includes the user and password
Start your app

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, do this:

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

@@ Line 1: / Line 1: @@
-To switch your Tunrkey site from using the default SQLCompact to use SQLServer in Azure instead you go like this:
+<message>Write the content here to display this box</message>
-# Login to you MDrivenServer (yoursite/__MDrivenServer  - credetials in portal.MDriven.net )
+To switch your Turnkey site from using the default SQLCompact to using the SQLServer in Azure instead, do this:
+# Login to you MDrivenServer (yoursite/__MDrivenServer  - credentials in portal.MDriven.net)
 # Go to AdminArea / Model Version Administration
 # Select A0
-# Pause your App with Pause button
+# Pause your App with the Pause button
 # Change ConnectionType to SqlServer
-# Paste in ConnectionString that includes user and pwd
+# Paste in ConnectionString that includes the user and password
 # Start your app
-[[File:2017-02-25 13h18 19.png|none|thumb]]
+[[File:2017-02-25 13h18 19.png|none|thumb|678x678px]]
-This will make your app look in the SQLServer instead of the default CompactDB
+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.'''
-But your SQLServer is still empty! '''MDriven must create the schema.'''
+To signal MDriven to drop everything and re-create the schema, do this:
-To signal MDriven to drop everything and re create the schema you go like this:
 # Make sure you have the model locally in MDrivenDesigner
-# Delete ALL VERSIONS of the model in MDriven Server - so that the list is empty and contains NO MODELS
+# Delete ALL VERSIONS of the model in MDriven Server so that the list is empty and contains NO MODELS
 # Upload the model from MDrivenDesigner
-# MDriven Server will now find that there is no old model to evolve and it will recreate the database as a result
+# MDriven Server will now find that there is no old model to evolve and will recreate the database as a result
 [[Category:MDriven Server]]
 [[Category:SQL]]
+{{Edited|July|12|2025}}