New user here trying to get started - I'd like to create an ORM map from an existing legacy (SQL Server) database - although I may convert this to Postgres or MySQL.
So what is the least painful approach to creating the ORM (I plan to use TurboGears to create some Web Front End screens to this database.) Most of the ORM docs I've read seem to require that the schema be defined in the ORM tool - however for a large legacy db that seems like a lot of work. I'd like to reverse engineer the db and create/ derive the maps/relationships from the SQL catalog - Is this possible? Am I missing something obvious here? More specifically, can I reverse migrate (??terminology??) from an existing production database and have all the foreign keys/database constraints/table relationships recognized and get models and controllers generated correctly? I'd like to avoid any hand coding (e.g. tweaking FKs/relationships) as part of this initial migration. Any links to relevant ref materials/tutorials/etc would be appreciated here. Thx in advance, Brendan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
