Migrate Access Database to SQL Server

In this blog article, we will examine how to migrate existing Microsoft Access databases to SQL Server in AutoCAD Electrical.

Migrate Access Database to SQL Server

Setup SQL Server Instance

Firstly, we need to create a SQL instance on a server which we will use to transfer the existing Microsoft Access databases to SQL Server. If you already have an existing SQL instance on the server, i.e., for Autodesk Vault, you can use this instance to transfer the databases.

Autodesk Content Migration Utility

  1. Start the Autodesk Content Migration Utility for AutoCAD Electrical from the Start menu (Windows)or the desktop icon
  2. On the home page of the utility, click Create and Migrate Database workflow.

Connect to SQL Server Instance

  1. In the SQL Server Link, navigate and select the appropriate server instance for your SQL Server connection.
  2. Under Authentication, either:
    1. Use the Windows authentication.
    2. Use SQL Server authentication. Enter your username and password.
  3. Click Next.

The connection to the SQL Server instance gets established.

Create Database on SQL Server

  1. Select the Create catalogue database, and then enter the name for your catalogue database on SQL Server.
  2. Select the Create footprint database, and then enter the name for your footprint database on SQL Server.
  3. Click Create.

The catalogue and footprint databases are now created on the SQL Server.

Note: You can either continue your data migration workflow from Access to SQL Server or come back later to do the data migration.

Migrate Database on SQL Server

  1. Select Provide a source for catalogue database, and then browse to navigate to your source catalogue database (.mdb)
  2. Select Provide source for footprint database, and then browse to navigate to your source footprint database (.mdb)
  3. Click Migrate.

If your migration is successful, the utility displays a success message; otherwise, it displays the error messages for a failed migration.

If you would like further information on the benefits of using AutoCAD Electrical for your electrical design, please get in touch with us at Symetri to arrange a consultation with one of our electrical specialists by filling in our form. We offer scheduled AutoCAD Electrical Essentials training and bespoke training tailored to your requirements to help you work smarter for a better future.


How CQi Automates CAD Deployments and Reduces Risk

05 September 2025

In modern Architecture, engineering, construction and design environments, the pressure is on IT teams to deliver fast, consistent, and secure software setups. Whether you're supporting ten users or ten thousand, manual installation methods simply can’t keep up with the demands of large-scale CAD environments. That’s where CQi (Configuration Intelligence)steps in. At Symetri, we developed CQi to help organisations automate CAD deployment, reduce risk, and maintain standardisation—all without increasing the burden on IT departments. In this blog, we’ll explore how CQi works and why it’s becoming a go-to solution for smarter CAD management.

Security Gaps You Didn't Know You Had

26 August 2025

As cybersecurity threats continue to evolve, some of the biggest risks to your organisation might not be obvious. In this month’s IT Bulletin, we shine a light on three critical security concerns that are often underestimated or overlooked entirely. These issues can silently compromise systems, leak data, or be exploited without detection.