Installation guide

Data model installation

Each data model is delivered as a collection of ready-to-run SQL DDL scripts that create the entire database schema (tables, columns, primary keys, and foreign keys) using syntax specific to each database system. Installation steps and requirements are the same for every data model.

Download

Licensed editions download steps

• Sign in to your Data Model Pack account.
• Go to Data Models page.
• Select the data model for which you want to export the SQL DDL scripts.
• Push the Data Model button. Your data model overview page opens.
• Push the Export button.
• Select Export SQL DDL.
• Select the target database (MS SQL Server, MySQL, Oracle etc.).
• Push the Save button.
• Read carefully the License Agreement.

Demo edition download steps

• Go to Data Models page.
• Navigate to the data model you want to download the Demo edition.
• Push the Data Model button.
• Your data model overview page opens. Navigate to the SQL DDL scripts section.
• Push the Download the demo SQL DDL scripts button to download your demo copy of the data model.
• Extract the files from the demo .ZIP archive.
• Read carefully the Demo edition terms of use.

Learn more about Data Model Pack editions.

SQL DDL scripts deployment

or

Case 1: Run the pre-built SQL DDL scripts directly in your database

Create database schema objects

You need a database instance up and running and a database admin account to deploy the SQL DDL scripts to the database.

• Create a new empty database schema. For example the SQL command to create a new empty database schema in MySQL is: create schema 'schema-name';
• Open your SQL management console and connect to the new database schema.
• Open the [data-model-name]-MySQL-Create.ddl file in your SQL management console.
• Run the [data-model-name]-MySQL-Create.ddl file to create the data model objects in the database schema.

Delete database schema objects

If you need to delete the database schema objects:

• Open your SQL management console and connect to the new database schema.
• Open the [data-model-name]-MySQL-Drop.ddl file in your SQL management console.
• Run the [data-model-name]-MySQL-Drop.ddl file to drop all the data model objects from the database schema.

Follow similar steps to create the database schema objects for all supported database engines: MS SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere and more.

You have full access to the Create and Drop SQL DDL scripts for all of these databases:

[data-model-name]-MS-SQL-Server-Create.ddl

[data-model-name]-MS-SQL-Server-Drop.ddl

[data-model-name]-MS-SQL-Server-Drop.ddl

[data-model-name]-Oracle-Create.ddl

[data-model-name]-Oracle-Drop.ddl

[data-model-name]-PostgreSQL-Create.ddl

[data-model-name]-PostgreSQL-Drop.ddl

[data-model-name]-Sybase-SQL-Anywhere-Create.ddl

[data-model-name]-Sybase-SQL-Anywhere-Drop.ddl

 and more.

See the full list of supported databases

Case 2: Import the pre-built SQL DDL scripts into any database design tool

You can import the pre-built SQL DDL scripts into any database design tool that can generate ER Diagrams and database schemas from SQL DDL files. Example of database design tools with this capability: erwin Data Modeler, Visual Paradigm, Sparx Systems Enterprise Architect etc

License Agreement

Please read carefully the License Agreement before starting to use any of the Data Model Pack editions. The License Agreement is a legal agreement between You (an individual person or the company you represent) as the Licensee of the Software and Data Model Pack as the Owner and Licensor of the Software. The Software means the computer software, associated documentation and any materials made available by Data Model Pack.