Migrate a Django project from MySQL to Oracle
- by pablo
Hi,
I have a Django1.1 project that works with a legacy MySQL db.
I'm trying to migrate this project to Oracle (xe and 11g).
We have two options for the migration:
- Use SQL developer to create a migration sql script.
- Use Django fixtures.
The schema created with the sql script from sql developer doesn't match the schema created from syncdb. For example, Django expects TIMESTAMP columns while sql developer creates DATE columns.
Using syncdb with Django fixtures could be great but when trying to load the MySQL fixtures into Oracle, after using syncdb, I'm getting:
IntegrityError: ORA-00001: unique constraint (USER.SYS_C004253) violated
How can I find what part create the integrity error?
Thanks