Languages :

English • Français

DataBase Migration

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases.

Source : fabFORCE.net

• Organization file :
  • Root Node of the DB structure : /DBMODEL/METADATA
    • /DBMODEL/SETTINGS contains only specifical informations
• METADATA node organization :

  <METADATA>
  <REGIONS>....</REGIONS>
  <TABLES>
     <TABLE
        <COLUMNS>
           <COLUMN/>
           ...
           <COLUMN/>
        </COLUMNS>
        <RELATIONS_START>
           <RELATION_START/>
        </RELATIONS_START>
        <RELATIONS_END>
           <RELATION_END/>
        </RELATIONS_END>
        <INDICES>
           <INDEX>
              <INDEXCOLUMNS>
                 <INDEXCOLUMN/>
              </INDEXCOLUMNS>
           </INDEX>
        </INDICES>
     </TABLE>
  </TABLES>
  <RELATIONS>
     <RELATION .... />
  </RELATIONS>
  </METADATA>
  ...

Middle MetaModel

A middle MetaModel has been created between the ER formalisme and the MetaModel BlueXML. The goal of this metamodel is to store all informations about DB structure :

• XML Schema
• RelaxNG

XSL Stylesheet

• DBD_to_InterMetaModel.xsl
• InterMetaModel_to_BlueXML.xsl

ToDo

• ENUM and SET can be transformed to Enumeration

BlueXML Model

The obtained file is usable by BlueXML Developer Studio.