> Are the table structures identical in both databases ? if so, then I would > not double up the declarative classes in this way - I'd use one class to > represent a particular table structure, which can then be used in either > session. You're already using two different Session objects, so there is no > need to specify different classes just to distinguish these. > > OTOH, if the table structures do differ among the two databases, and you do > in fact need to define each class twice, you just need to use two separate > declarative bases so that they no longer share the same MetaData object. >
The table structures are slightly different. I created a separate declarative base as you suggested and all is working correctly now. Thank you for the quick response, this should get be going until the next problem! -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.