AnatolyUss / nmig

NMIG is a database migration tool, written in Node.js and highly inspired by FromMySqlToPostgreSql.
GNU General Public License v3.0
451 stars 83 forks source link

Constraints are not migrated #101

Open robert-sjoblom opened 1 year ago

robert-sjoblom commented 1 year ago

Set up two databases.

MySQL: https://github.com/datacharmer/test_db Postgres: Empty

Move data from MySQL to Postgres.

Expected:

All constraints are created on PG side

Actual:

Constraint is not created on PG side (index for the constraint is, however, created)

AnatolyFromPerion commented 1 year ago

Hello, I apologize for late response. Could you share a sample of what actually didn't work, please?

robert-sjoblom commented 1 year ago

test_db has several constraints. I would expect those to be migrated, but they're not. The indexes backing those constraints are, however.