Home » Developer & Programmer » Forms » Oracle and MSSQL
Oracle and MSSQL [message #215812] Wed, 24 January 2007 00:08 Go to next message
nick048
Messages: 36
Registered: February 2006
Member
Hi All,

I have 2 applications.
The first is a commercial application, based on MSSQL database.
The second, created with Oracle Developer Suite, is based on Oracle 10g database.

Exist a method, in order to extract data from MSSQL tables and populate an Oracle table?

If yes, how can perform this ?

I hope in Your help.

Thank You and Best Regards.

Gaetano

Report message to a moderator

Re: Oracle and MSSQL [message #216070 is a reply to message #215812] Wed, 24 January 2007 22:25 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Are you going to do this once (then look at Oracle's Migration tool) or do you want to 'communicate'/'retrieve data' in one system from the other?

David

Report message to a moderator

Re: Oracle and MSSQL [message #218074 is a reply to message #215812] Tue, 06 February 2007 13:16 Go to previous message
buenospfc
Messages: 1
Registered: February 2007
Junior Member
Hello Gaetano,

I think that the best option is export data from MSSQL to txt file, you can to use dts for to do this and before import file to Oracle using tool import.

Report message to a moderator

Previous Topic: Problem with post text item trigger
Next Topic: workaround for locking due to multiple user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 22:09:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.