Hi Everybody
How are you? I think you are all well. But i have some problem. I have two pc. One pc uses SQLServer database and another uses oracle database software. I need some data from the SQLServer to Oracle. How can i transfer data from SQLServer to Oracle or ViceVersa? Is there any software to do this? Is there any trail version that can i used to evaluate my problem? Can anyone help me to give me some information or suggetion? Thanks all.

Regards
Shimul Mahmud

You should be able to set up the Oracle instance as a linked server on the SQL Server machine, providing you have the Oracle connectivity tools installed. Alternatively take a look at the OPENQUERY function in SQL Server whereby the connection details are passed as part of the query.

Alternatively you can use Oracle to connect to SQL Server: http://www.databasejournal.com/featu...SQL-Server.htm although it's more hassle in my opinion.

__________________
Joe
http://joe.fawcett.name/