hi mike , all the 3 databases have same tables but may have different data. i need to get all the data from 3 databases.
On Wed, Nov 7, 2012 at 8:22 PM, Michael Bayer <[email protected]>wrote: > > when you say "get data from 3 databases" it sounds like each of these > databases has a different set of tables within them. this is called > vertical partitioning. horizontal partitioning is when each of the three > databases contain identical schemas, each storing a subset of the data for > those tables. > > if you're vertically partitioning, the Session will switch among different > databases based on the tables you ask for. A brief description of that is > here: > http://docs.sqlalchemy.org/en/latest/orm/session.html#simple-vertical-partitioning. > Later on in that section is a description of horizontal partitioning, > which is a more involved technique. > > > > > On Nov 7, 2012, at 1:46 AM, kampy wrote: > > Hi all, > > I have requirement where i need to get data from 3 databases and integrate > all the data. while searching i found there is support in SQLAlchemy by > using horizantal sharding, but i didnt get any correct procedural way to do > it. if anyone had done these kind of requirement please help me out in > getting these things. > > Thanks in Advance > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/BPIp2h2Ryz8J. > 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. > > > -- > 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. > -- Thanks & Regards, Narasimha +( 91 )-9704008535 -- 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.
