Again, thank you for a great job. This is the best converter from Access to MySQL - I tried several..
The feature which could be extremely useful - detailed INSERT in the dump file. By detailed I mean generation of INSERT statements like "INSERT INTO table SET field1='value1', field2='value2' ...". This is extremely useful when importing into SQL database big amounts of data from Access/Excel tables with incomplete field set (usually while data migration of merging databases) or converting databases.
Apoligies, if I am mistaking, and this feature already implemented, but I did not found it in the latest release.
Feature - detailed INSERT
Moderator: jr
Hi Jacob,
I meant setting all the fields from MS Access table (or those I have choosen in the fields list). Right now it generates insert statements like "INSERT INTO table VALUES (value1, value2...)". But I propose to generate like "INSERT INTO table SET field1='value1', field2='value2' ...".
This will execute the insert without SQL error even when number of fields in source and destnation databases are not the same.
For example:
I have Mysql database of contacts, which consist of 20 fields, including address, phones, ICQ, email and other fields. And I have a list of my friends from my Outlook, which has only name and email. I can export my email address book into MS Access and then try to import into MySQL. If I use "INSERT INTO table VALUES (value1, value2...)", than fields in the MS Access table and MySQL table should be the same, but it is not! So this will generate an error.
On the other hand, if I use "INSERT INTO table SET field1='value1', field2='value2' ..." which will include only name and email - it will import into MySQL all my email address book, leaving other fields empty.
I meant setting all the fields from MS Access table (or those I have choosen in the fields list). Right now it generates insert statements like "INSERT INTO table VALUES (value1, value2...)". But I propose to generate like "INSERT INTO table SET field1='value1', field2='value2' ...".
This will execute the insert without SQL error even when number of fields in source and destnation databases are not the same.
For example:
I have Mysql database of contacts, which consist of 20 fields, including address, phones, ICQ, email and other fields. And I have a list of my friends from my Outlook, which has only name and email. I can export my email address book into MS Access and then try to import into MySQL. If I use "INSERT INTO table VALUES (value1, value2...)", than fields in the MS Access table and MySQL table should be the same, but it is not! So this will generate an error.
On the other hand, if I use "INSERT INTO table SET field1='value1', field2='value2' ..." which will include only name and email - it will import into MySQL all my email address book, leaving other fields empty.
-
vitalijkopz
- Posts: 1
- Joined: Tue Dec 12, 2006 6:58 pm
[quote="serg"]Again, thank you for a great job. This is the best converter from Access to MySQL - I tried several....[/quote]That means is not present?
_________________
Effective intellectual advertising at forums. Analogues are not present. e-mail: info@advv.ru, ICQ: 352734559
_________________
Effective intellectual advertising at forums. Analogues are not present. e-mail: info@advv.ru, ICQ: 352734559
-
taquitosensei
- Posts: 2
- Joined: Fri Jul 11, 2008 9:01 pm