MicroOLAP
HOME  >> PRODUCTS  >> DOWNLOADS  >> ORDER  >> SUBSCRIPTION SUPPORT
NEWS
SUBSCRIBE
SCREENSHOTS

Database Designer for MSSQL

Database structure modeling, generation and modification focused on MSSQL

Database Designer for MSSQL is an easy CASE tool with intuitive graphical interface allowing you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures, functions, programability objects and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.
Take a look at the MySQL version and the PostgreSQL version of the product.

Inside Database Designer for MSSQL

Database Representation
Place objects of your database on a diagram, a virtual sheet of paper. See and realize the structure of your database and its objects: tables, views, stored procedures, functions and relationships between them. Construct schemas, domains, tables, indexes, columns and triggers.
You can import already existing databases to a diagram by reverse engineering.
Easy Database Generation and Maintenance
With the database designer you can quickly create a ready-to-use MSSQL database with a few clicks, and then keeping its structure up-to-date by synchronizing it with the changes you made to a visual diagram. Simply change the diagram  — Designer will generate complex SQL statement for database modification to bring it to the state of diagram keeping data in safe. Moreover, you can synchronize several databases to the state of your diagram.
Documentation: Printing, Generating Graphics and Reports
Generate powerful reports that describe all the database objects within your diagram. You can export graphical representation of diagram to EMF, JPEG, PNG, GIF and other popular formats or print the diagram out on multiple pages.

Product Overview

Database Designer for MSSQL makes the process of database creation clear and simplifies maintenance of the databases. All the operations performed in a fast, handy and intuitive interface.
The product designed for popular MSSQL database server and takes into account all its features including:

  • MSSQL's extensions to SQL and T-SQL syntax;
  • MSSQL's support of CLR code.
  • stored procedures: T-SQL and CLR procedures;
  • functions: scalar, inline table-valued , multistatement table-valued, CLR scalar, CLR table valued functions;
  • check, unique and primary key constraints;
  • indexes: clustered, nonclustered, unique, primary xml, secondary xml, full-text.
  • foreign key references;
  • database files and groups;
  • table's and viewe's triggers;
  • assemblies;
  • user data types and aliases;
  • partition functions;
  • partition schemas;
  • XML schema collections;
  • agregates;
  • full-text catalogs;
  • schemas.
  • Support of MSSQL server starting from 2000 and a partial support of MSSQL 2008


The product can extract tables, attributes, relationships, indexes and other objects from existing databases including MSSQL, Microsoft Access, MySQL, Sybase ASE/ASA, Oracle, Informix, MSSQL, DB2, DBF and many others that accessible through OLEDB or ODBC and import (reverse engineer) them into your diagram.

In the end, you'll get a Physical Entity Relationship Model (ER Model) that can be exported in SQL script, or directly executed on working MSSQL database server. After making changes to a diagram, you can synchronize existing MSSQL database with it by using Database Modification tool.

Critical bug fixed by the MicroOLAP Database Designer v1.10.1 release

07/10/2014
Critical bug in the Reverse Engineering fixed. Everybody should consider upgrading to this version as soon as possible!

Check the new Database Designer for PostgreSQL 1.10.0

07/03/2014
This release introduces support for the latest v9.4 SQL grammar as well as improved support for inheritance functionality. Modify Engine allows mark constraints as NOT VALID. Several non critical bugs fixed.

DAC for MySQL 2.9.7 is out!

05/08/2014
Support for RAD Studio XE6 added, several minor improvements and bug fixes.

PostgresDAC 2.12.0 meets RAD Studio XE6!

05/01/2014
PostgresDAC v2.12.0 with support for Delphi XE6 and C++ Builder XE6 is available immediately!

PaGoDump and PaGoRestore v9.3 released

04/14/2014
PostgreSQL v9.3 support introduced.

More news ›

RSS
2.0

OFFER
Special Offer
Educational Licenses
Educational Classroom and Educational Institution Site Licenses at discounted price
Site map | Search | Privacy Policy | Terms of Use | Contact Us
Copyright © 2000—2014 MicroOLAP Technologies LTD. All Rights Reserved.
All trademarks are the sole property of their respective owners.