cadalyst
AutoCAD

Configure AutoCAD Electrical 2017 Databases for Use with Microsoft SQL

14 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


More News and Resources from Cadalyst Partners

Cadalyst Benchmark Test

Running AutoCAD? Test Your Hardware! Designed to test and compare the performance of systems running AutoCAD, Cadalyst's Benchmark Test is a popular and long-time favorite.

Learn more and download the Cadalyst Benchmark Test.


Take the Gradual Path to BIMWhite Paper: Take the Gradual Path to BIM. Implementing building information modeling (BIM) can be a daunting challenge, but you don't have to take on everything at once. Learn how small, incremental advances can yield big benefits over time. Download your paper today!


Discover DraftSight(R) - the capabilities of Autocad(c) and more at the right price. DraftSight is a 2D and 3D CAD solution that can create, edit, view and markup any DWG file with greater ease, speed and efficiency. Learn more here.