Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We are planning to support for our application another rdbms (oracle).

At the moment we are design our database schema with the MySQL-Workbench. For every new database version we have

  • schema er-diagram
  • a full schema sql script (create table.., create index..., create trigger..., ...)
  • and a migrate sql script (alter table...., drop index, create index..., ...)
  • and finally a data file which all in it (*.mwb file)

We use table, index, stored routines, views and triggers. We want a tool, where we can design the table, relations, views, triggers and routines and export a full schema sql script for different rdbms and an migration sql skipt to upgrade a database for different rdbms.

Now my question. Is the any tool available, which is able to do the above stuff for both MySQL and Oracle?

I look at AnySQL Maestro, Navicat Premion, Altova DatabaseSpy but all loose information (mostly the triggers). I found also this wikipage, but i can't figure out, which have the feature we need.

EDIT: clarification:

Atilla Ozgur (see his answer) is right. A want a tool whit a logical model including triggers and procedure and which is able to export all the things (especially triggers and routines) to different (at the moment MySQL and Oracle) physical models. The export should be done by sql scripts.

share|improve this question
    
You do understand that the procedural language(s)/capabilities are totally different between MySQL and Oracle? There is no automatic way of converting one to the other if that is what you are after. –  Jack Douglas Dec 1 '11 at 11:27
    
I'm aware of this. But is it real impossible to design also triggers in meta logical schema and translate this in different physical layer languages? I don't want to convert the schema between mysql and oracle. I just can't believe that we must design and migrate always two logical schema. –  Lars Dec 1 '11 at 11:38
add comment

2 Answers

up vote 3 down vote accepted

Last time I have used it (but that's a long time ago) Sybase PowerDesigner was able to handle triggers and procedures for all supported DBMS.

Looking at the current manuals, that still seems to be the case.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc38058.1600/doc/html/rad1232020719541.html

Although I don't see MySQL mentioned there.

share|improve this answer
add comment

You want to be able to design and develop following objects.

  • table
  • index
  • stored routines
  • views
  • triggers.

Modelling tools will be able to help you with table, views and indexes. These tools are called with different names. Entity Relationship tools, Database Diagram, Database Modelling tools.

Some examples are :

You will design your data model, logical model, using these tools. After that you will export your physical model to different databases. Something like below.

1 logical
  1 physical Oracle
  1 physical Mysql
  1 physical Sql Server

I do not know if there exists any tool which will be able to help you write stored procedures and triggers in one place and export them to different databases. These change from database to database a lot. Sql server uses TSQL for trigger and stored procedures. Oracle uses PLSQL

share|improve this answer
    
Thanx for the answers, but i definitely asked for tool which able to export triggers and procedures to different physical models. I probably update my question. –  Lars Dec 1 '11 at 9:32
    
your title: "Schema development and migration tool for multiple rdbms (mysql, oracle) available" suggest otherwise. –  Atilla Ozgur Dec 1 '11 at 10:05
    
Atilla Ozgur: thanks for your advice. I updated the title. –  Lars Dec 1 '11 at 11:15
    
I think "development and migration tool for multiple rdbms, especially trigger and stored procedures" something along these lines may be better. Since you said " i definitely asked for tool which able to export triggers and procedures to different physical models." –  Atilla Ozgur Dec 1 '11 at 11:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.