ddl

XMLtoDB let you create DDL files from XML files. DDL files can be used to create new tables in a database.

You simply have to execute the DDL script in your favorite SQL editor and the new tables will be created.

Open Databases, show the contents and the structure over the ODBC-Drivers without having the original Database frontent. Run SQL-Statements or DDL - and all within the Windows-Explorer.

MagicDraw provides full support for UML 2.0 metamodel, including class, use case, communication, sequence, state, activity, implementation, package, component, composite structure, and deployment diagrams. In addition, MagicDraw provides explicit support for UML profiles and custom diagrams.

MagicDraw provides a means for architectural view modeling: to define system and software architecture in all 4+1 views, and at different abstraction levels.
MagicDraw automatically generates your model parts in accordance with established design patterns: GoF, Java, EJB, JUnit, XML Schema, WSDL, CORBA IDL, and any of your customizable patterns.
With MagicDraw s visualization and analysis wizards, you can easily import an UML model from any source XMI import or a reverse engineering operation and visually display it.

Support for integrated modeling. With a few simple clicks, create an integrated development environment by meshing MagicDraw with Eclipse, IBMs WebSphere Application Developer and Rational Application Developer, Borland s JBuilder, IntelliJ IDEA, NetBeans, Sun s Java Studio, BEA WebLogic Workshop.

With MagicDraw UML you may integrate your data models with business and OO models. UML profile for DDL enables mapping of relational concepts to UML elements. MagicDraw gives you a tool for generating and reversing DDL Scripts, retrieving Database Structure (Schema) via JDBC.

Another data modeling powerful tool is model transformations in both Platform Independent Model (PIM) to Platform Specific Model (PSM) and PSM to PIM:
UML to Generic DDL: transforms your conceptual UML model to generic DDL model;
DDL to UML: transforms your generic DDL model to conceptual UML model;
UML to Oracle DDL: transforms your conceptual UML model to specific Oracle DDL model;
UML to XML Schema: transforms your conceptual UML model to XML Schema;
XML Schema to UML: transforms your XML Schema to conceptual UML model.

Database Comparer helps to compare, synchronize and update databases structure.

You can compare one database with another database or database with DDL/SQL script or even two DDL/SQL scripts!

Database Comparer supports following servers: InterBase SQL server and its clones - FireBird and Yaffil (Yaffil teamrecently announced merge with FireBird); SQL Anywhere.Visual Basic, VC++ demos code; Full indexed help system.

Database Comparer helps to compare, synchronize and update databases structure. You can compare one database with another database or database with DDL/SQL script or even two DDL/SQL scripts! Database Comparer supports following servers: InterBase SQL server and its clones - FireBird and Yaffil (Yaffil team recently announced merge with FireBird); SQL Anywhere. Borland InterBase Express components library (IBX) is used by default to work with InterBase / FireBird. Alternatively Database Comparer supports Fast InterBase Plus components by Devrace (FIBPlus).Delphi demos code; Full indexed help system.Installations for Delphi 5, 6 and 7.

Shark DB Expert allows you to connect multi-database in the same time. Exampe Oracle, Sybase, MS SQL, DB2, MS Access, MySQL, Paradox, DBF, MS Execl, Text. List Table/View/Procedure/User-Define-Function/System Table(Only in MS SQL,Sybase)/ When connection is Oracle,the following db object will be listed Synonym/Package/Sequence/Cluster/Dynamic performance view. Powerful SQL builder & parser.

It is a visual tool to create a sql. Generate data dictionary then export to excel file/html file. Generate DDL and recreate db object and export DDL to SQL File. Localizable including Chinese (Simplified),Chinese (Traditional),English.

Starting from now the Database Comparer supports Delphi 2005.

Database Comparer helps you to compare, synchronize and update databases structure. You may compare one database with another database or database with SQL/DDL script or even two SQL/DDL scripts!

Database Comparer implements highly intelligent and robust synchronization algorithm. During first comparison step it takes Target database or Target SQL/DDL script and compare it to the Master database or Master SQL/DDL script trying to locate all structure differences and prepare final SQL script which will be applied to the Target and make its structure equal to Master structure.

At this stage Database Comparer extracts all objects, descriptions and links from both Master and Target structures and then compares actual objects from Master with objects from Target building final update SQL script. After final update SQL script is ready you can apply it to the Target database if it is available or just save it to the file and run it later.

Database Comparer supports following servers:

InterBase SQL server and its clones - FireBird and Yaffil (Yaffil team recently announced merge with FireBird)
SQL Anywhere

Borland InterBase Express components library (IBX) is used by default to work with InterBase / FireBird. Alternatively Database Comparer supports Fast InterBase Plus components by Devrace (FIBPlus) and Interbase Objects (IBO) library.

Database Comparer can connect directly to the InterBase/FireBird databases via IBX or FIBPlus thus directly performs all operations such as database metadata extraction, SQL statements and scripts execution etc.

SQL Anywhere support is limited. Database Comparer can only work with SQL Anywhere scripts and can not connect directly to SQL Anywhere. You will have to provide Database Comparer with both master and target database scripts which will be parsed and compared. Result will be the DDL/SQL script which needs to be applied to the target database in order make target database structure fully identical to the master database structure.

The most unique features of the Database Comparer VCL are ability to perform full analysis of all types of the database objects and its properties and generate the DDL/SQL script which will transform structure of the target database and makes it totally identical to the structure of the source database.

Generated DDL/SQL script can be executed by TIBSQLExec component on "statement by statement" basis and thus all errors which may occur during target database structure conversion process will be detected and properly resolved.

Limitations:

· Database Comparer library comes with full sources (demo versions does not have sources), detailed help and demo projects.


Whats New in This Release:

· Delphi 2005 support.
· Comparing of the MySql scripts was implemented.

XTG Data Modeller is a visual CASE tool for data structure modelling. Main features: Modelling using a GUI, attribute repository, reengineering via ODBC or from SQL schema. Generation of TXT reports, SQL scripts (DDL), DML/DQL commands, HTML documentation of the model with hypertext cross-references between entities. Multidimensional modelling. IDEF1X methodology. Referential integrity, modelling of both the logical and physical level, indexes, definition of roles of attributes...