AutoCAD Electrical 2017 What’s New Information
Posted on April 18, 2016 by Synergis Manufacturing Applications Consultant, Todd Schmoock
One of the most exciting new features for AutoCAD Electrical 2017 has to be the Microsoft SQL Server support for catalog data. This can be setup during installation, or afterwards if you have already installed the software. There are two options for setting this up. Deployment Mode, and Standalone Mode.
If you know you want to use the SQL option before you install AutoCAD Electrical 2017 you will want to do Deployment Mode. In the deployment mode, you can connect to your SQL Server instance. The SQL Server instance should already be created by your database/system administrator. For creating an SQL Server instance, use the Autodesk Content Migration Utility for AutoCAD Electrical, which is a tool that helps in creating and migrating your database from Microsoft® Access to Microsoft® SQL™ Server. Here is the dialog box that displays when using this option:
If you are already using AutoCAD Electrical 2017 then you will use the Standalone Mode. In the standalone mode, you can configure your SQL Server from the product. Use the AECATALOGCONFIG command to open the Configure Database dialog box that allows you to connect, and then select your catalog and footprint databases on an SQL Server instance. Here is the dialog box that displays when using this option:
Another option to consider is Content Migration Utility which is a lightweight GUI-based migration tool that allows you to create AutoCAD Electrical catalog database (catalog and footprint databases) on an SQL Server instance. Using the same utility, you can migrate the default catalog data, which is furnished in Microsoft® Access tables to an SQL Server instance. Here is the dialog box that displays when using this option:
In the Create and Migrate database workflow, the utility prompts you to connect to an instance of SQL Server. After a successful connection, the utility allows you to name your catalog and footprint target database tables in SQL Server. Once you have created your target databases, use the utility to navigate and select your existing catalog and footprint databases (.mdb) to begin the migration process.
In the Migrate database workflow, the utility prompts you to select the catalog and footprint databases, which exists on the SQL Server. After you have selected, the utility allows you to navigate and select your existing catalog and footprint databases (.mdb) to begin the migration process.
The content migration utility supports catalog database file formats for AutoCAD Electrical 2015 or later version. If your catalog database has an older format; it is recommended that you migrate your database to 2015 (or later version) before using this utility.
For several years Autodesk wanted to move to the SQL Server support for AutoCAD Electrical due to how large the Microsoft® Access database can get if you enter all of the vendors you use in a typical AutoCAD Electrical project. Additionally, the Microsoft® Access database re-indexes every time you do a catalog lookup so the larger the database the more issues you will have moving forward with it. So whether you are planning on moving to AutoCAD Electrical 2017, or are a current user you should consider using the SQL Server option for your catalog data.