Migrate from `ndb` to SQLalchemy?

Samuel Marks 0
Viewed 51

How do I migrate a codebase from ndb to SQLalchemy?

Tempted to write a parser/emitter, taking in the 40+ ndb.Model of my codebase and generate sqlalchemy.schema.Table or Base inheriting classes. But that doesn't:

  1. solve the data migration problem;
  2. doesn't enable a middle-road, where I can access data before migrating;
  3. requires manual work in migrating all the query syntax over

Happy to do the work, but asking here in case there's a better way (e.g., I saw this 10-year old question Can SQLAlchemy be used with Google Cloud SQL? ; or maybe some way of dumping the schema directly from ndb to SQL then from SQL directly to SQLalchemy).

ndb google-cloud-datastore google-app-engine sqlalchemy python
1 Answers

To migrate you need to write a migration script that will copy data from ndb to SQL. You can't do it automatically. You can't do it partially. You can't do it in a way that will allow you to access data before migrating. You can't do it without manual work. You can't do it without writing a migration script.

Tibic40
Related