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.

Blog

Vulnerability Management

18 June 2024

To ensure that your network and endpoints are secure, you need to ensure that vulnerabilities are patched, and devices configured to ensure that the risk of a threat is lowered.

Learn more