SQL Server shared network database

You can use SQL Server for your network database. This gives better performance and reliability for your network database.

Microsoft SQL Server Express is a free edition of SQL Server that you may use to host the tools and materials database used by FeatureCAM.

When using Microsoft SQL Express to host your FeatureCAM tools and materials you need a server computer to host the SQL Server software and the tools/materials database. This server computer should be a different computer from the client computer where users are running FeatureCAM.

Note: The database server can host tools and materials databases from different versions of FeatureCAM, or different parts of your organization.

Installation

  1. Pick a computer at your facility that you want to host the FeatureCAM tools and materials database. We'll call this the database server. The database server must meet these criteria:
    • It must be running Microsoft Windows.
    • It must be connected to your network.
    • It must be able to run Microsoft SQL Server Express.
  2. Find out the hostname of the database server.
  3. Install Microsoft SQL Server Express on your database server.
  4. From any client computer using FeatureCAM, find INITDB in the Start menu and run it.
  5. In the Tool and Material Setup dialog, select On a SQL Server and enter the hostname of the database server computer as the Server Name.
  6. After entering the Server Name, you can select an existing database on the database server in the Database Name menu, or create a new one.
  7. The first time you run INITDB you can do one of the following:
    • Initialize a new database with all the default tools.
    • Import tools from another database elsewhere on your network
    • Upgrade an existing database to the latest version of FeatureCAM and load it with all of the default tooling.

    Subsequent client installations default to this choice.