Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #15374 > unrolled thread

SQLAlchemy DB Migration

Back to article view | Back to comp.lang.python

Contents

  SQLAlchemy DB Migration Merwin <merwin.irc@gmail.com> - 2011-11-06 10:44 +0100

#15374 — SQLAlchemy DB Migration

Hi everybody,

I'm looking for a way to migrate SQLAlchemy based database easily. I 
found Migrate, but finally it's almost the same as doing the migration 
by hand.

If this doesn't exists, do you think that it would be hard to do a 
simple migration tool which would :

     - Add/Delete columns from DB if they are not anymore in the models 
(With a confirmation for deletion)
     - Add/Delete constraints/sequences on table if they are not on the 
model too

We could also imagine a way to :

     - Handle column rename, with data copy from one to another
     - Handle column type change, with proper data conversion

Of course, such a system can't be 100% automated, that's not the goal. 
Human interventation will be needed, but it might be more simpler for 
simple cases than Migrate.

--
Thibaut

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web