How to convert an Access database to a SQL database

Tech-Tip: How to convert an Access database to a SQL database

Menu

This video will show you how simple it is to convert an Access Database (.mdb) to a SQL Database using Zuken’s DBTool application.

Step 1) Open SQL Server Management Tool

Step 2) Create a new blank database

Step 3) Navigate to your DBTool.exe file and open

Step 4) Configure your Access database

Step 5) Select “Start” to begin copying the Access Database to the SQL Database

Step 6) Configure the SQL Database in E3.series. **See link below for pdf version of “How to configure a database”**

How to configure a database PDF

*Note: This video does not have sound

Alex Bitzer
Alex Bitzer
Applications Engineer
Alex Bitzer is an applications engineer, covering both the Zuken global support hotline and delivering in-person training. Her work focuses on educating both new and experienced customers on the workings of E3.series. In her spare time she loves to make props for cosplaying and attending conventions.
learn to setup an E3.series project
  • Blog
November 26, 2024
Mastering E3.series #3: Connecting Parts and Managing Cables

Learn how to efficiently add components and connectors from the E3.series database to your electrical designs. Explore techniques for managing device properties, working with blocks, and ensuring data integrity in your projects. Perfect for engineers looking to streamline their schematic and wire harness workflows.

Read now
learn to setup an E3.series project
  • Blog
November 18, 2024
How to add Components and Connectors in E3.series

Learn how to efficiently add components and connectors from the E3.series database to your electrical designs. Explore techniques for managing device properties, working with blocks, and ensuring data integrity in your projects. Perfect for engineers looking to streamline their schematic and wire harness workflows.

Read now
Mastering E3.series with Harry - Episode 2
wp-header-1920x844-sherpa-510x310
  • Blog
October 28, 2024
Advancing Mobile Robotics Applications

Sherpa Mobile Robotics, a European AMR designer and manufacturer, was founded to automate shop floor material flow using robots to deliver items to order pickers. Today, they provide turnkey solutions to meet the rising demand for efficient intralogistics automation.

Read now
learn to setup an E3.series project
  • Blog
October 23, 2024
Episode 4: How to Export and Generate Reports

In this episode of Mastering E3.series, we explore how to prepare your project for release, covering everything from PDF exports to generating detailed reports. Learn how to utilize the powerful tools within E3.series to create bill of materials and use the report generator.

Read now