I work in a financial institution that has two database management systems: Oracle and MSSQL. We need to integrate those for transactions transfer. How are automatic transfer and processing of a file with transactions, generated by Oracle, realized in MSSQL (linked servers, stored procedures)? Is it a reliable solution?
This is a common requirement. SQL Server 2005 includes support for native Oracle replication. Presuming the two servers can be linked over a network, you can use the standard replication system that comes with SQL Server 2005 to do this. It is very reliable.
Dig deeper on Microsoft SQL Server Installation
Related Q&A from Greg Low
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know.continue reading
Find how to query in SQL Server to get all database names created by users.continue reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.