These steps should be done after configuring SQL Express as described in the article: SQL 2016: Configuring SQL Express
The Toolbox interface used is from 15.4.x so some windows may look different.
After configuring SQL Express, data needs to be imported into the database that has been made. These steps must be run on a computer that already has Toolbox 7 installed.
- In the options page in Toolbox and click on the Data Access tab.
- Select SQL Server and click the dropdown for Data Source and select the instance that has your SQL server’s name on it followed by SQLEXPRESS or the name provided for the SQL instance during installation.
- Select Windows Authentication or SQL Server Authentication
- If SQL Server Authentication, fill out the SQL Server User Name and Password
- You must do this before clicking the drop-down for Data Catalog – especially if it is using SQL Server Authentication
- The Data Source should be Computer name\Instance name.
- If you do not see the instance name, or cannot find the computer name listed, then the firewall on the server will need to be adjusted.
- Use the drop-down for Data Catalog to find the database that was previously created.
- Once the Data Source and Data Catalog are filled out correctly, click the Transfer Tables button.
- If you hit Test Connection, you will see “Could Not Read Tables in Catalog” – this is due to the database being empty
- Once the Transfer Tables dialog box opens, select the Transfer to SQL Server radio button.
- Under the database group with Microvellum Factory selected, choose the Select SQL CE Database button, navigate to where the compact database exists and select it, then select the Transfer button at the bottom of the dialog box.
- You can get libraries from here: https://microvellum.zendesk.com/hc/en-us/articles/214586126-Component-Cabinet-Library
- You will be prompted that the data on SQL Server will be overwritten, select OK.
- Transfer Tables should only be done once from a primary workstation, once the tables are transferred, the remaining workstations just need to be set to SQL Server, select the correct Data Source and Data Catalog.
- The program will now migrate all your data into SQL, repeat the process for Microvellum Graphics, the Secure database does not need to be transferred unless you are using Employee Login (Secure).
- When the transfers are completed, the Transfer Tables dialog box will close and you will be back at the Options screen.
- Once it has finished and you have transferred the MicrovellumFactory.sdf and MicrovellumGraphics.sdf, restart the program and verify the data is there. The program is now ready to be used.
- The last step in configuring Microvellum is to move the path to Microvellum Data. It should be put onto a network drive that all Microvellum users can see and have full control of. To do this, browse to where the data is located. The default location is “C:\Users\%userprofile%\AppData\Local\Microvellum\Common Microvellum Data”. Copy the Microvellum Data folder to the network location.
- Now each user needs to point to the new location. To do this, click the Change Path to Microvellum Data button while still on the Options screen. Navigate to the network location to where you copied the data folder to in the previous steps.
- 15.4 versions and below - It will be under Data Access > Change Path to Microvellum Data
- 15.5 versions and above - It will be under Utilities > Change Path to Microvellum Data