Migrate Mysql to Cache

Question

Question

Natasa Klenovsek Arh · Jan 18, 2017

Hy.

Is there a way to migrate MySql db to Cache (like export from MySql and import to Cache - not just the data, but the properties of the table too)?

Thank you.

Discussion (3)0

Log in or sign up to continue

Dmitry Maslennikov · Jan 18, 2017

You can try to export all from MySQL, and import to Caché, with command

Do $SYSTEM.SQL.DDLImport("MySQL","_SYSTEM","C:\export.sql")

You can also do import in the System Management Portal. Or migrate data from ODBC source.

1 0

score 0 · Answer 1 · 2017-01-19T02:40:38-05:00

Natasa Klenovsek Arh · Jan 19, 2017

Great, that worked, thank you :-)

0 0

score 0 · Answer 2 · 2017-03-23T07:47:51-04:00

Just been in same situation yesterday and the migrate from ODBC worked for us. We needed the data in Cache for Reports, Dashboards, etc.

The new challenge is: the application that uses MySQL is not yet re-coded to use Cache, so the data is still written in MySQL. Using ODBC to do what we want was giving all sorts of errors... (due to restrictions and limitations for external sources as mentioned in these docs.). After migrating the data, no issues at all.

Is there a way OR does anyone know how to keep the migrated data always in Sync? If data is written in MySQL it's automatically synced into Cache (... well in Cache speak this will be shadow, mirror, etc). Or custom polling needs to be written?

Regards;

Anzelem.