Import Navision Data =>mysql DB

Business Central/NAV Technical Forum
1

Hi everybody, I want to import quite a lot of data from the Navision Database (*.fdb) into a mysql database. Unfortunaly I cannot establish any connection via ODBC from mysql to Navision [:(] Does somebody has got a few ideas for me ??? Thank you in advance for any help… Michael

2

Do it the other way around: connect to MySQL ODBC from Navision. You can do this with the use of Microsoft ActiveX Data Objects in Navision’s C/SIDE.

3

Or dump the data in textfiles and call the import in mysql with SHELL()

4

Or contact www.databackbone.dk. They have a prof replicator also to be used when replicating between Navision and Mysql.

5

Hi, I have a codeunit here showing how to connect to SQL, read and write with queries, and close the connection. You just have to send me an email if you want a copy…