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.
Industrial Automation: A focused engineer interacts with a futuristic holographic interface, showcasing the power of advanced technology in a modern industrial setting
  • Blog
December 05, 2024
Designing the Future: Challenges and Innovations in Industrial IoT

From automation to real-time analytics, the Industrial Internet of Things (IIoT) is fundamentally transforming industries. But behind the opportunities lie challenges: Can security, legacy equipment, and complex systems be seamlessly integrated? Discover how smart factories of the future are being shaped and why the IIoT is the key to it all.

Read now
learn to setup an E3.series project
  • Blog
December 03, 2024
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
Mastering E3.series with Harry - Episode 4
learn to setup an E3.series project
  • Blog
November 26, 2024
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
Mastering E3.series with Harry - Episode 3
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