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.
This Content Component encountered an error
Related Q&A from Greg Low
Learn why using the sp_OACreate stored procedure with a SQL Server 2005 trigger, is likely to result in a permissions problem.continue reading
A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading
Find how to query in SQL Server to get all database names created by users.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.