• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

SQL Server To Oracle

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.

------------------
 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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).]
 
reply
    Bookmark Topic Watch Topic
  • New Topic