On Tuesday 10 June 2008 20:22:08 Paul Johnston wrote: > Hi, > > >My development team and me are working in a application to migrate > > Oracle databases to PostgreSQL databases, and we need this > > information to do this. > > I've done successful migrations using autocode, > http://code.google.com/p/sqlautocode/ > > The procedure, roughly is: > 1) Use autocode to generate sqlalchemy definitions from your > existing database > 2) Create the tables in a new database - which can be a different > kind of database > 3) Use a sqlalchemy program to copy the table data > > As for the program to use for (3), I've used a throwaway script, > but I think there's something in dbcook > (http://pypi.python.org/pypi/dbcook/0.2) you could use. it also has autocode-like script called autoload (will need touching for back-mapping oracle types), a schema and data copiers, and a metadata-diff; see dbcook/misc/metadata/; these are all using plain sqlalchemy. e.g. $ python copyall.py srcurl desturl will (eventualy) autoload and copy everything
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---