Home » SQL & PL/SQL » SQL & PL/SQL » SQL Server to Oracle data migration
SQL Server to Oracle data migration [message #165218] Tue, 28 March 2006 23:41 Go to next message
Smith_a
Messages: 2
Registered: March 2006
Junior Member
Hi,

Apart from Oracle migration work bench, Can you please suggest me some of the data migration tool available to port my data from SQL Server to Oracle.

Also let me know your experience, if any on those tools.

Smitha
Re: SQL Server to Oracle data migration [message #176857 is a reply to message #165218] Sat, 10 June 2006 10:16 Go to previous messageGo to next message
Babboo.com
Messages: 5
Registered: May 2006
Junior Member
You might want to think about connecting to SQL Server from within Oracle through Oracle's heterogeneous services ODBC agent. I have never used it extensively so use with caution.

There are many examples out there but here is an article that should get you started:
http://www.databasejournal.com/features/oracle/article.php/3442661

http://www.pinehorse.com/images/babbooLogoW.gif
Effortless Cloning of Oracle databases and Oracle applicatons
www.babboo.com

Re: SQL Server to Oracle data migration [message #176928 is a reply to message #165218] Mon, 12 June 2006 01:21 Go to previous messageGo to next message
oralover
Messages: 97
Registered: January 2005
Member
DBPut Pro Cool
Converting data between different databases.

DBPut data transfer is a creative and advanced software used for converting data between different databases. such as: MySQL, Oracle, DB2, Microsoft SQL Server Sybase, Access, dBase, Paradox, Foxpro, Text etc. With the DBPut data transfer transferring and maintaining databases is a snap, even though you are a rookie in SQL grammar.
Re: SQL Server to Oracle data migration [message #238714 is a reply to message #176928] Sat, 19 May 2007 11:37 Go to previous message
convertin
Messages: 14
Registered: May 2007
Junior Member
Try MSSQL-to-Oracle conversion tool by Intelligent Converters:

http://www.convert-in.com/mss2ora.htm

It has quite fast conversion engine, simple user interface. Hope this will help.
Previous Topic: Is this a valid package name &&subvar1..emp_demo_pkg
Next Topic: junk characters passed over db link
Goto Forum:
  


Current Time: Wed Dec 07 14:17:41 CST 2016

Total time taken to generate the page: 0.05116 seconds