[sqlalchemy] Multi Database Relationship With Primay Join (MSSQL)

2013-07-12 Thread Victor Reichert
Hello, I am attempting to implement a relationship accross two MSSQL databases that may or may not be on the samer server. The catch is that MSSQL does not support cross database forgien key contraints (the tables must be in the same db). I am trying to to implement the relationship with a

Re: [sqlalchemy] Multi Database Relationship With Primay Join (MSSQL)

2013-07-12 Thread Michael Bayer
On Jul 12, 2013, at 5:35 PM, Victor Reichert vfr...@gmail.com wrote: Simulated_Events.sim = ServerName.Temp_DB.dbo.Simulation_Catalog_Table.Sims and Simulated_Events.event_id = ServerName.Temp_DB.dbo.Simulation_Catalog_Table.EventID ^ SyntaxError: invalid