Configuration Editor: Data Access Options
SQL CE
The database type "SQL Compact Edition" or "SQLCE" is a database file stored within the Factory Database folder. It has an SDF file extension, and some users call it a 'local' database, meaning that it resides locally on each computer. This is not to be confused with the SQL Local database discussed in the next section, "SQL Local (LocalDB)."
This is the default database type used when you install Toolbox.
SQL Compact Edition is limited to a single connection to the database at any one time. This means that if you have a company where multiple Users need to access the same data, you cannot use this database type and will need to set up a SQL Server type database.
SQL Local (Local DB)
Structured Query Language Local Database. SQL Local DB copies a minimal set of files necessary to start the SQL Server Database Engine. SQL Local DB is suitable for a single-user or multi-user environment. SQL Local has a 10GB limit imposed by Microsoft. SQL Local DB is part of the Microvellum process to transition from an Individual Work Order Database to a single Unified Work Order Database.
SQL Local - Factory Connection
Used to convert a Factory SQL CE Database to an SQL Local (LocalDB) Database. Click the button Transfer SqlCe to Sql Local to initiate the process.
SQL Local - Work Order Connection
Used to convert Work Order SQL CE Databases into a single SQL Local Database. This step is necessary when transitioning to a single work order SQL Server database. Specify the type of database before clicking on the button Transfer SqlCe to Sql Local.
SQL Server
The SQL Server database type supports the connection of multiple computers connected to the same data through a network. To use this database type, you must first set up a SQL Server using Microsoft SQL Studio Manager. For more information on installing and configuring SQL Server, creating a database instance, and adding users see the following four-part tutorial:
SQL Server - Factory Authentication
SQL Server databases require authentication information to establish a successful connection. The configuration of the SQL Server instance determines the type of Authentication necessary in this section, as well as the User Name and Password.
Windows – Uses internal Windows user data to connect to the SQL Server database. You must configure the server instance with one option or the other when you create the server instance.
SQL Server – Uses the "SQL Server User Name" and "SQL Server Password" entered in the same area of the interface.
SQL Server - Factory Connection
SQL Server instances and their databases require Data Source and Data Catalog information for a successful connection.
Data Source – Specifies the SQL Server instance name containing the desired database.
Data Catalog – Specifies the SQL Server database name to which you are connecting.
Test Factory Connection – Verifies the connection to the Factory database to ensure successful communication with the SQL Server.
Transfer SQLCE to SQL Server – Transfers an existing SQL CE Database to the SQL Server Database. Transfer will overwrite all existing SQL Server Information. Use caution with this command if you are transferring data to an existing database.
SQL Server - Work Order Authentication
The "Unified Work Order Database" SQL Server database requires authentication information for a successful connection. The configuration of the SQL Server instance determines the type of Authentication necessary in this section, as well as the User Name and Password.
Windows – Uses internal Windows user data to connect to the SQL Server database. You must configure the server instance with one option or the other when you create the server instance.
SQL Server – Uses the "SQL Server User Name" and "SQL Server Password" entered in the same area of the interface.
SQL Server - Work Order Connection
Unified Work Order Database connection settings. Data Source and Data Catalog (Work Order and Geometry) information required for a successful connection to the SQL Server and Database.
Data Source – Specifies the SQL Server Unified Work Order Database instance name containing the desired database.
Data Catalog (Work Order) – Specifies the SQL Server Unified Work Order Database name to which you are connecting.
Data Catalog (Geometry) – Specifies the SQL Server Unified Geometry Database name to which you are connecting.
Test Work Order Connection – Verifies the connection to the Unified Work Order database to ensure successful communication to the SQL Server.
Test Geometry Connection – Verifies the connection to the Unified Geometry database to ensure successful communication to the SQL Server.
Transfer SQLCE to SQL Server – Transfers an existing SQL CE Database to the SQL Server Database. Transfer will overwrite all existing SQL Server Information. Use caution with this command if you are transferring data to an existing database.
SQL Relay
The SQL Relay database type is for use only with Microvellum Production Time Clock. With that app, it supports time entry via a remote device and requires setup services performed by Microvellum Technicians. It is not used for Toolbox at this time.
Related Articles
Overview: Configuration Editor (Options) Interface
The Configuration Editor (Options) Interface for Microvellum Toolbox is accessible from the Toolbox Setup menu. Using the options contained within, you'll configure general system settings, set up the optimization software you use, set up tool files, ...Configuration Editor: Utilities Options
This article provides an overview of the options and settings available on the Utilities tab of the Configuration Editor (Options) Interface. For a complete list of available tabs and options visit Overview: Configuration Editor (Options) Interface. ...Configuration Editor: Processing Options
This article provides an overview of the options and settings available on the Processing tab of the Configuration Editor (Options) Interface. For a complete list of available tabs and options visit Overview: Configuration Editor (Options) Interface. ...Configuration Editor: Machining Options
This article provides an overview of the options and settings available on the Machining tab of the Configuration Editor (Options) Interface. For a complete list of available tabs and options visit Overview: Configuration Editor (Options) Interface. ...Configuration Editor: General Options
This article provides an overview of the options and settings available on the General tab of the Configuration Editor (Options) Interface. For a complete list of available tabs and options visit Overview: Configuration Editor (Options) Interface. ...
Recent Articles
Toolbox Release Notes | Build 24.1.1206.641
The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...Microvellum Foundation Library Release Notes | Build 24.1127
The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...Toolbox Release Notes | Build 24.1.1125.641
The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...Toolbox Release Notes | Build 24.1.1105.641
The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...Microvellum Foundation Library Release Notes | Build 24.1025
The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...