Hi all!
I have a MSSQL SERVER I want to use sqlalchemy on, because there are
some old databases in there and legacy applications and we can't
migrate the data for now. (although a migration is planned and
SQLAlchemy is helping a lot)
The server has two Databases (table collections) lets call them DataA
and DataB. Both are on the same MSSQL SERVER.
If i create a MSSQL engine like this:
import sqlalchemy as sa
e = sa.create_engine('mssql://myuser:sec...@myserver/DataA',
echo=True)
e.execute('SELECT * FROM TableInA')
The engine points to the 'DataA' database, so that works. I get a
result object with all rows from TableInA;
But I still can access/join with a table in DataB by running:
e.execute('SELECT * FROM DataB.dbo.TableInB')
That works too, so I get rows from TableInB which is in DataB, a
different database from the one I used when creating the engine
object. I can even JOIN tables from DataB with tables in DataA, no
problem.
Question is: How can I do that in a sa.Table constructor?
I have tried:
sa.Table('DataB.dbo.TableInB', metadata, ....)
sa.Table('TableInB', metadata, ...., schema='DataB.dbo')
And both failed. Is there a way to map tables from both databases
using the same engine? So I can do a JOIN between the tables?
Thanks in advance
nosklo
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
