Transferring Data to an SQL Server Database (Unified Work Order Database)(Tutorial 4)

Transferring Data to an SQL Server Database (Unified Work Order Database)(Tutorial 4)

This is the fourth in a series of tutorials presenting the steps necessary to install and configure a new SQL Server database to work within Microvellum. It focuses on how to transfer data to new SQL Server databases.

Click here to view the third tutorial in the series. 

By now, you should have already installed a new SQL Server database instance and configured that new server with two new databases. 

You should also have set up the necessary logins, mapped those user logins to the appropriate databases, and set the role memberships for the user logins.

Lastly, you should have already configured your Microvellum software to connect to those databases. 

The last step is to transfer existing factory data to the new SQL Server factory database, and the data from each existing Work Order database into the two unified work order databases (work order and geometry).
  1. With Toolbox open, click “Toolbox Setup > Options > Data Access > SQL Server” and in the Factory Connection section, click the button “Transfer SqlCe to SQL Server. Allow the transfer to complete and a message box to appear confirming the transfer.

    2. Fig. 1

     
    Fig. 2
  1. In the Work Order Connection section, click the button “Transfer SqlCe to SQL Server. Allow the transfer to complete and a message box to appear confirming the transfer. The data will be transferred to the appropriate work order or geometry database.

    2. Fig. 3
  1. Test the three SQL Server database connections again as you did in the previous tutorial. This time the message box should confirm that the connection was successful, as shown in Fig. 4.

    2. Fig. 4
  1. Close Toolbox and reopen using the configuration you just modified. Create a test project, room, work order, etc. to test the connections made in this tutorial entirely.