Documentation:Database download and upload: Difference between revisions

Database download and upload

Revision as of 11:10, 23 May 2018

If you want to test some new thing and don`t move your app on the new site or you want to make a backup of your app you can use this Snapshot and Upload function.

Snapshot and download

Start MDriven Designer and head to "CloudForm" tab, if it's needed please log in in your MDriven Turnkey account.

Choose the web site which you want to backup.

Choose the site you needed to backup/replace.

After choosing the site head to Admin DB Access and Swap tab.

Press "Snapshot Admin DB" to take a snapshot of your database.

Take a snapshot of your admin database.

After this, you can download your DB on your computer by clicking the "Download Snapshot Admin db" button.

Upload the datebase snapshot

To upload your database snapshot you need to choose the site you need.

Head to Admin DB Access and Swap tab and choose the path to your local database snapshot.

Choose your local DB copy.

Click "Upload Admin db for replace".

You can use this as a simple backup solution.

Opening and viewing the database snapshot

If you want to open the downloaded DatabaseCompact.sdf database file, we recommend using Linqpad (http://www.linqpad.net).

When opening the sdf-file, select SQL CE 4.0 driver. If Linqpad can't find the driver, download Microsoft SQL Server Compact 4.0 database driver from Microsoft and install it, then restart Linqpad.

Please note that all database tables are prefixed with A0_ for the modelled database and Admin_ for the MDriven servers own database.

To make your experience more comfortable, we set the main tags mentioned in the video to the right bar menu of this mini player. Choose the interesting subtitle on the list and immediately get to the exact theme timeplace in the video. Now you can pick any topic to be instructed without watching the whole video.

This page was edited more than 9 months ago on 03/26/2024. What links here

@@ Line 29: / Line 29: @@
 Please note that all database tables are prefixed with '''A0_''' for the modelled database and '''Admin_''' for the MDriven servers own database.
-== Video tutorial ==
 <html>
-<p class="warn">
-<em>To make your experience more comfortable, we set the main tags mentioned in the video to the right bar menu of this mini player. Choose the interesting subtitle on the list and immediately get to the exact theme timeplace in the video. Now you can pick any topic to be instructed without watching the whole video.</em> </p>
-<style type="text/css">
- p.warn {
-opacity: 0.6;
-text-align: justify;
-opacity: 0.7
-width: 90%
-}
-#video12 {
-  position: relative;
-  padding-bottom: 10px;
-}
-#video12::after {
-  content: "";
-  display: table;
-  clear: both;
-}
-#video12 iframe {
-  width: 100%;
-  min-width: 200px;
-  max-width: 740px;
-  height: 500px;
-  float: left;
-}
-@media (max-width: 767px) {
+<p class="video-warn">
-   #video12 iframe {
+   To make your experience more comfortable, we set the main tags mentioned in the video to the right bar menu of this mini
-    height: 180px;
+  player. Choose the interesting subtitle on the list and immediately get to the exact theme timeplace in the video. Now
-   }
+   you can pick any topic to be instructed without watching the whole video.
-}
+</p>
-#video12 div {
+<div class="video">
-  float: left;
+   <div class="video__wrapper">
-  padding-left: 10px;
+    <iframe src="https://www.youtube.com/embed/mtOHl-AsyNU?rel=0&autoplay=0" frameborder="0" allowfullscreen></iframe>
-	overflow-y: auto;
+   </div>
-	height: 500px;
+  <div class="video__navigation">
-}
+      <span class="navigation-item" data-video="mtOHl-AsyNU" data-start="0" tabindex="0"> Snapshot and upload </span>
-span.time {
+      <span class="navigation-item" data-video="mtOHl-AsyNU" data-start="40" tabindex="0"> Admin DB Access and Swap </span>
-    display:block;
+      <span class="navigation-item" data-video="mtOHl-AsyNU" data-start="213" tabindex="0"> Bringing back the Model with the Snapshot </span>
-   padding: 2px 10px 2px 10px;
+      <span class="navigation-item" data-video="mtOHl-AsyNU" data-start="341" tabindex="0"> Newest Version of the Turnkey software
-    padding-bottom: 0.5em;
-    padding-top: 0.5em;
-  opacity: 0.7;
-}
-span.time:hover {
-  color: #0000FF;
-  cursor: pointer;
-}
-span.time:focus {
-  color: blue;
-}
-</style>
-<br>
-<div id="video12">
- <iframe width="740" height="500" src="https://www.youtube.com/embed/mtOHl-AsyNU?rel=0&autoplay=0" frameborder="0" allowfullscreen></iframe>
-   <div>
-    <span class="time" data-video="mtOHl-AsyNU" data-start="40" tabindex="0"> Admin DB Access and Swap </span>
-    <span class="time" data-video="mtOHl-AsyNU" data-start="213" tabindex="0"> Bringing back the Model with the Snapshot </span>
-    <span class="time" data-video="mtOHl-AsyNU" data-start="341" tabindex="0">  Newest Version of the Turnkey software
      (portal.MDriven.net) </span>
-</div>
+  </div>
 </div>
-<script>
-var IMG = document.querySelectorAll('#video12 span'),
-    IFRAME = document.querySelector('#video12 iframe');
-for (var i = 0; i < IMG.length; i++) {
-  IMG[i].onclick = function() {
-    IFRAME.src = 'https://www.youtube.com/embed/' + this.dataset.video + '?rel=0&autoplay=1';
-    if(this.dataset.end) IFRAME.src = IFRAME.src.replace(/([\s\S]*)/g, '$1&end=' + this.dataset.end);
-    if(this.dataset.start) IFRAME.src = IFRAME.src.replace(/([\s\S]*)/g, '$1&start=' + this.dataset.start);
-    this.style.backgroundColor='rgba(0,0,0,.2)';
-  }
-}
-</script>
 </html>