aspose file tools*
The moose likes JDBC and the fly likes SQL Server To Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server To Oracle" Watch "SQL Server To Oracle" New topic
Author

SQL Server To Oracle

ad
Greenhorn

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
Hi,
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.
Bye.

------------------
Srinivasa Dhamodharan
Greenhorn

Joined: Oct 17, 2000
Posts: 19
Hi!
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.

Thanks
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
jUST MY OPINION...
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL Server To Oracle
 
Similar Threads
Oracle 9i developer cert
Java Stored Procedure to execute exp.exe for taking BACKUPS
Is it hard to use SQL Server with Java?
Java Stored Procedure to execute exp.exe for taking BACKUPS
Java Stored Procedure in SQL Server