Use SqlServer
No edit summary |
(Replacing message template with parser tag) |
||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
To switch your | <message>Write the content here to display this box</message> | ||
# Login to you MDrivenServer (yoursite/__MDrivenServer - | 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 | # Go to AdminArea / Model Version Administration | ||
# Select A0 | # Select A0 | ||
# Pause your App with Pause button | # Pause your App with the Pause button | ||
# Change ConnectionType to SqlServer | # Change ConnectionType to SqlServer | ||
# Paste in ConnectionString that includes user and | # Paste in ConnectionString that includes the user and password | ||
# Start your app | # 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 | 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: | |||
To signal MDriven to drop everything and re create the schema | |||
# Make sure you have the model locally in MDrivenDesigner | # Make sure you have the model locally in MDrivenDesigner | ||
# Delete ALL VERSIONS of the model in MDriven Server | # Delete ALL VERSIONS of the model in MDriven Server so that the list is empty and contains NO MODELS | ||
# Upload the model from MDrivenDesigner | # Upload the model from MDrivenDesigner | ||
# MDriven Server will now find that there is no old model to evolve and | # 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:MDriven Server]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
{{Edited|July|12|2024}} |
Latest revision as of 07:59, 17 June 2024
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
This page was edited 104 days ago on 06/17/2024. What links here