my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes SQL Server To Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Server To Oracle" Watch "SQL Server To Oracle" New topic

SQL Server To Oracle


Joined: Sep 19, 2000
Posts: 1
Hello all,
What is the best way to import SQL Server dump(Backup) from a client machine to a server using Java ? Is this even possible ? Once I have access to this backup, I plan to restore this backup into a Oracle databse. Basically converting Sql server database into a Oracle data. I was hoping to use Java. Could anyone suggest/guide me in the right direction ? Are their any security implications I must take into consideration ?
Thanks a lot.
Prabhu Chandrasekaran
Ranch Hand

Joined: Oct 14, 2000
Posts: 36
I don't know how to port SQL Server database to Oracle using Java. But if you only want to port data from one database to another database, you can use the "DTS" utility that comes along with SQL Server 7.0. It is very easy to use.

Srinivasa Dhamodharan

Joined: Oct 17, 2000
Posts: 19
There are 2 standard ways to port Data into Oracle from other
databases, both of them are based on the data that we have in flat files , one is using sql*loader (which needs a delimited flat file) and other one is through pro*c programs.Apart from that you can write pipelines with C which connects to both databases and transfers data.I dont know if writing anything in Java for this purpose will be of much help, If I am wrong please
let me know about the highlight of Using Java for this.

Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
A Basic Design:
1. Create to connection references pointing to both of your database engines. That 2 referrences.
2. Code sql to select/extract data from one engine.
3. Put the ResultSet into a Vector table ...
4. Batch the ResultSet to insert into the second db engine.
To fill in the design blanks. It is just a simple matter of programming.
Hope this helps
We learn more from our mistake's than from our success's.
[This message has been edited by Monty Ireland (edited October 18, 2000).]

Multi Platform Database Developer & DBA on E.S.T.
It is sorta covered in the JavaRanch Style Guide.
subject: SQL Server To Oracle
It's not a secret anymore!