This document explains the steps required to configure a local sandbox from an SQL server. For additional information about what a “sandbox” is and when to use one click here. Prior to creating a sandbox environment, we strongly recommend the user back up their production data.
Steps to set up a local sandbox from an SQL server
Open Microvellum in an SQL Server configuration.
At the top of the main Microvellum palette, hover over “Help” and select “Browse to Factory Data."
Navigate up one folder by selecting the “up” arrow (see below).
Create a Copy of the folder containing the Factory Database, Work Orders, etc… Name the copied folder “Sandbox Local."
To save time and Hard Drive storage, you may want to create your Sandbox Local folder structure and pick and choose just a few test projects and work orders to copy along with your core Microvellum data, instead of copying the whole folder structure and all contents.
Enter the “Sandbox Local” folder -> enter the “Factory Database” folder.
Delete the database called MicrovellumFactory.sdf.
Restart Microvellum > Select “Manage Configurations."
Copy the SQL Server Configuration and rename it to “Sandbox Local."
In the main Microvellum palette, select the “Microvellum Setup” tab and select “Options."
Select the “Utilities” tab > Select “Transfer Tables” > Select the radio buttons “Transfer to SQL CE" and “Factory Database” > Select “Transfer” (see below).
Observe the “Browse For Folder” window will appear.
Enter the Sandbox Local Folder (created in step 4) and select the “Factory Database” Folder > Press “Ok”. Wait until the process is completed.
Start Microvellum in Sandbox Local configuration.
Select “Microvellum Setup” > “Options."
Select the “Data Access” tab and select the SQL CE radio button.
Select the “Utilities” tab and select “Change Path to Microvellum Data."
Select the “Sandbox Local” folder and press the “Select Folder” button.
The sandbox SQL server configuration is now complete and ready for testing.