Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database transformation

 
Anil HN
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic