This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Database transformation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Database transformation" Watch "Database transformation" New topic
Author

Database transformation

Anil HN
Greenhorn

Joined: Jun 24, 2002
Posts: 3
Suppose if i have two databses one sql server & another oracle & i have to transfer the database from sql to oracle(not using any build in features)using Programming language what r the steps involved
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Well you really have some choices. Is this in one program, what is the programming language, you can use ODBC, or JDBC, or DSN to make two connections and then use the data.
If you just want to migrate, Oracle has a migration tool, or you can export the data into a text file from SQLServer and then use SQL Loader to load the data.
It all depends on what your end goals are.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Database transformation
 
Similar Threads
Network Adapter
wether JDBC supports UNION Queries
How is Oracle JDBC different?
Why PL/SQL when you could use Java?
Date Insertion using XSU...