nomofoxpro
Programmer
The system that I am working on will soon be split between MS SQL 7 and Oracle 10g. There are a few stored procedures right now that join between multiple databases on our existing SQL 7 platform. Some of the databases are going to be moved to Oracle so I will need a way to gather the same data that I am today but instead of between 2 MS SQL dbs on the same server I will need to do this between 1 db on MS SQL and 1 on Oracle. Right now I am thinking about creating 1 record set from sql and then one from Oracle and then manually joining then in Oracle to create the final recordset that I am looking for. Any ideas on the best way to do this?