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 Civil 3D 2026 can support your workflows

16 April 2025

In this blog post, our Principal Consultant, Enrique Barriuso, takes a closer look at what's new in Autodesk Civil 3D 2026. Building on previous versions, this release brings a range of new features, enhancements, and updates.

OPTIMISING BIM & DIGITAL: IN ARCHITECTURE & ENGINEERING

14 April 2025

Optimising BIM and digital tools in architecture and engineering is revolutionising the industry. By integrating technologies like AI, cloud computing, and data analytics, professionals can enhance collaboration, reduce errors, and streamline workflows. In this blog, we'll explore how leveraging these tools can lead to more efficient and successful project outcomes.

How Inventor 2026 can support your workflows

07 April 2025

Consultant James Lodge explores what’s new in Autodesk Inventor Professional 2026. Including smarter workflows, a modern UI, enhanced sheet metal tools, and improved Revit interoperability to boost performance and cross-team collaboration.