linked server compares between Oracle and SQL Server

59 views Asked by At

We are doing a migration from Oracle 10g to SQL Server 2014. Once I set up the linked Server connection in SQL Server to the Oracle DB will I be able to run a statement like the following:

select * from linkedservername...schema.table
except
select * from Servername.database.schema.table

Not all queries will be this easy as I'll have to do some data manipulation on the oracle side. Will I need to use Oracle syntax for that or once I have the linked server set up will everything be in T-SQL for querying purposes?

Thanks

0

There are 0 answers