Import Access to MS SQL

Support Wissensdatenbank

Du bist hier:
Print

Import Access database to Microsoft SQL Server

This tutorial will help you to convert accdb, mdb databases to SQL and then add it to SQL Server. We will use the script from https://github.com/miguel93041/accessmysqlconverter

  1. Install python and pip on your computer
  2. pip install –no-cache-dir –upgrade accessmysqlconverter
  3. python -m accessmysqlconverter.application
  4. Now follow the instructions on the screen and select the appropriate .accdb or .mdb file.
  5. Afterwards a .sql file will be generated. You can then import this file into your database in SQL Server Management Studio.

 

War dieser Artikel hilfreich?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
Wie können wir diesen Artikel verbessern?
Please submit the reason for your vote so that we can improve the article.
Brauchst du Hilfe?
Related Post