Synchronizing local database with Remote Database
I am using an ASP page where I am fetching data from my local Oracle database. Now with a click of a SUBMIT Button I need to insert this data into SQL Server database located in a Remote Web Server. How can I do this?
Picking data from local Oracle Database is not a problem. Inserting it into Remote SQL Server Database is a problem. How to form a Connection String that I can use to insert data into remote SQL Server Database.
Can some one help me out. I need sample Connection strings to test it at my end.
Any help on this will be highly appreciated.