mercredi 4 novembre 2015

Migrate SQLIte Data in to MySQL and manage/update the foreign keys?

I´m developing an Android Application in which the data is stored in a SQLite database.

I have made de sync with a MySQL database, in the web, to where I’m sending the data stored in the SQLite in the device.

The problema is that I don’t know how to maintain the relations between tables, because the primary keys are going to be updated with AUTO_INCREMENT, and the foreign keys remain the same, breaking the relations between tables.

Can anyone help me?

Aucun commentaire:

Enregistrer un commentaire