CODEWITHSUNDEEP
mysql
Pask
Pask

Reputation: 335

convert Access to mysql commands

One of our customer has an Access database in his own server and I need to import it to a linux server with mysql in my own server. In other words, I need to convert Access to mysql commands (inserts basically).

I've tried the DBWScript which works fine although it does not allow to export only one table. It exports all tables. What I'm doing now is exporting all the tables to a sql file and then I filter it taking only the inserts I really need.

I'd like to know if anybody knows a software like DBWScript that can be run in console-mode and permits to export only one table from a database, because that table has a lot of rows (up to 100.000) and it has no sense to export all the other tables if I am not going to use them. That increases the conversion time a lot.

Upvotes: 0

Views: 352

Answers (3)

Pask
Pask

Reputation: 335

I finally used a software called "Bullzip MS Access to MySQL" and it works like a charm! This is the author's website: http://www.bullzip.com/products/a2m/info.php

It allows yo to select the desired table and desired columns in different tables, apart from creating a batch script to automate the process.

Upvotes: 1

Ivan Cachicatari
Ivan Cachicatari

Reputation: 4294

You can try using tips to converting MS Access to MySQL

Upvotes: 0

Devart
Devart

Reputation: 122042

You can try Data Import tool in dbForge Studio for SQL Server.

Open Data Import wizard, select MS Access format, specify other options and save template file. Then use this template file (*.dit) in command line mode.

Upvotes: 0

Related Questions