Configure AutoCAD Electrical 2017 Databases for Use with Microsoft SQL

15 Sep, 2016 By: Alex Karan

IMAGINiT 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. 

About the Author: Alex Karan

Alex Karan

Add comment

Note: Comments are moderated and will appear live after approval by the site moderator.

AutoCAD Tips!

Lynn Allen

In her easy-to-follow, friendly style, long-time Cadalyst contributing editor Lynn Allen guides you through a new feature or time-saving trick in every episode of her popular AutoCAD Video Tips. Subscribe to the free Cadalyst Video Picks newsletter, and we'll notify you every time a new video tip is published. All exclusively from Cadalyst!

Follow Lynn on TwitterFollow Lynn on Twitter

Do you use social media — such as Facebook or Twitter updates, YouTube videos, or discussion forums — for work-related purposes?
Yes, I regularly use such resources for work-related purposes.
Yes, but on a limited or infrequent basis.
No, because my employer frowns upon or prohibits doing so.
No, because I don’t have the time or interest.
Submit Vote

Download Cadalyst Magazine Special Edition