Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server To Oracle

 
ad
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic