• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

best way to migrate database

 
J. Kevin Robbins
Bartender
Pie
Posts: 1801
28
Chrome Eclipse IDE Firefox Browser jQuery Linux MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The old web server has an Oracle 10g database. The new server is running MariaDB. I need suggestions on exporting from Oracle and importing to MariaDB.

There must be tools out there that will take some of the pain out of this migration. Suggestions, please?
 
Brian Tkatch
Bartender
Posts: 567
25
Linux Notepad Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Structure, or just data?

Have a look here.
 
J. Kevin Robbins
Bartender
Pie
Posts: 1801
28
Chrome Eclipse IDE Firefox Browser jQuery Linux MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Great links, thanks. I need the structure. The MariaDB is a fresh install with nothing in it.

It looks like MySQL Workbench might be just the thing, if I can get past the support crap and get to the download.
 
Brian Tkatch
Bartender
Posts: 567
25
Linux Notepad Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQL Developer has a SQL tab which may work. If so, you can manually grab the SQL and modify it accordingly.
Toad probably does that too.
And Power Designer, if you have it and a stored data model, i think. At least, that's what our DA might be using as we unfortunately go from Oracle to SQL Server.
 
Roel De Nijs
Sheriff
Posts: 10666
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Brian Tkatch wrote:At least, that's what our DA might be using as we unfortunately go from Oracle to SQL Server.

Auwch! My condolences
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic