AutoCAD

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 and Autodesk Technical Evangelist 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


Poll
Which device do you typically use to read Cadalyst.com content?
A desktop computer / tower workstation
A tablet
A smartphone
A laptop or mobile workstation
I regularly use both a desktop computer and a smartphone for this purpose
I regularly use another combination of devices for this purpose
I prefer to print out articles from the website and read them on paper
Submit Vote



Download Cadalyst Magazine Special Edition