Design database and generate SQL/DDL code

Using CASE Studio 2, you will not only create ER diagrams, but also generate very detailed SQL (DDL) scripts! This product IS NOT a graphical software, which allows you to draw diagrams, lines and boxes only. It gives you the opportunity to get a full control over the final script, generate individual parts of your model, check the consistency etc. CASE Studio 2 allows you to generate even unsupported types of referential integrity using the triggers. SQL script generation would save you hundreds of hours.

Is this database design tool customizable? Yes!

Absolutely. You can affect the final SQL (DDL) code in several different ways. Firstly, you can select which model's objects will be generated. You can select or deselect the following parts of your models:

Domains
Tables
Primary keys, Alternate keys
Indexes
Referential integrity
Triggers, Procedures, Views
Roles, Role permissions, Users permissions

It is possible to choose other parts in dependence on the selected database. For Oracle's models, you can generate:

Quotations
Owners
Check constraint names, Unique constraint names
Comments on tables and attributes
Functions, Packages, Package bodies
Synonyms, Sequences and more.

For advanced users of CASE Studio 2

CASE Studio 2 gives you absolutely unique opportunity. Via the Templates, you can affect the process of SQL (DDL) code generation in full. It allows you to include into the script your own, additional insertions etc.

Tip

Double click an Entity name from the left Overview tree to edit the entity.

What Do They Say ?

Case Studio is a brilliant Modeling tool. It has saved me hundreds of hours of work. It is intuitive and a lot of thought has gone into power and usability. I have used other modelling tools and this is the best so far. It is a serious tool for busy Developers. After two months into a large project with Case Studio and C++ Builder, I would never use anything else. Full stop.

Dean Robinson
Director Pearce & Robinson LTD, Software Developers, Battle, UK

Generate SQL code

How to generate

Advanced

Entity list

SQL (DDL) script

For further information contact enquiries@advantages.co.nz