Configure AutoCAD Electrical 2017 Databases for Use with Microsoft SQL
14 Sep, 2016 By: Alex KaranIMAGINiT Tricks Tutorial: Follow these simple steps for quick configuration.
Editor's note: This tutorial courtesy of IMAGINiT Technologies.
To start, create and configure on the SQL server the Microsoft SQL instance AECATALOG. Note that the Microsoft SQL version should be 2008 or later.
Next, install Autodesk Content Migration Utility, which is not installed by default. Select “Install Tools & Utilities” in your installation wizard and Install “Autodesk Content Migration Utility.”
Select Content Migration Utility from Start – Autodesk menu.
In the Content Migration Utility dialog box select “Create and Migrate Database.” In the “Established Connection” dialog box, login to Microsoft SQL. In the “Database Details” define names for SQL BOM and Footprint databases. In the “Select Data to Migrate” field, provide the path to legacy Microsoft Access Databases (Default_Cat.mdb and Footprint.mdb) that you would like to migrate to Microsoft SQL Databases.
Open AutoCAD Electrical 2017 and select “Config Catalog Database” on the Project tab. In the “Config Database” dialog box, select the Microsoft SQL Server option. Select SQL Server link — SQL instance and click “Connect.”
To check if you are using SQL DB mode, look at Project Custom Settings.
For Mold Designers! Cadalyst has an area of our site focused on technologies and resources specific to the mold design professional. Sponsored by Siemens NX. Visit the Equipped Mold Designer here!
For Architects! Cadalyst has an area of our site focused on technologies and resources specific to the building design professional. Sponsored by HP. Visit the Equipped Architect here!