Now for the Stupid SQL Stuff
time to read 1 min | 123 words

Linking an Oracle database to a SQL Server one seems to be a deeply spiritual experience that involves a lot of meditation, playing with Oracle's client, using regsvr32 indiscriminately and then finding out that the queries aren't working. It gets more interesting when you're trying to run the queries, check out the syntax:

SELECT * FROM X..SYS.ALL OBJECTS;

As you can see, the syntax is obvious. And I'll say nothing about how I arrived to this after a lot of frustrations where it just couldn't find the proper tables. In the end, it was actually simplicity itself, of course that the query will be case sensitive (where both SQL Server & Oracle aren't).

Tweet Share Share 0 comments