ModelRight for SQL Server 3.0.0 Build 29

Do you need to development, visualize or document your SQL Server database?
ModelRight 3 for SQL Server can reverse engineer your existing SQL Server database to get a graphical view of it, make all the SQL statements to produce the database, or synchronize your database model with the database to protect your development up to date.

Do you need to control the most detailed aspects of your SQL Server database? ModelRight 3 for SQL Server has more complete and in-depth maintenance for SQL Server’s most advanced highlights. Plus, it has a modern PC user interface that allows for simple diagram editing and navigation.

ModelRight 3 for SQL Server provides all of these powerful characteristics (and a lot of more) to aid you generate the most complete and efficient database designs possible.

Whether you are a beginner or an professional database modeler, ModelRight 3 for SQL Server is your response when you need a database modeling utility that surpasses the “least common denominator” approach taken by others.
Try yourself and download ModelRight 3 for SQL Server. Database modelling has never been more expert and easier!

Main features:

• Model Validation
• Self-Validating Foundation
• An expandable/collapsible, categorized tree view of all your model objects.
• Reporting
• Create new Types, attributes, object tables, object views, etc…
• Display Options
• User-defined Properties
• Our innovative mode-less template of interaction is easy and intuitive. security Just click on an object in either the Model Explorer or Diagram to edit its properties. No need to pop up dialog on top of dialog to create modifications.
• ModelRight supports the usual database objects like Table, View, Index, Constraint (PK, FK, UK) and Oracle specific characteristics like, Materialized Views, Tablespaces, Clusters, Sequences, Packages, Procedures, Functions, Triggers, Synonyms, Schemas, Index-organized tables, Table and Index (Local and Global) Partitions, LOB storage options, REF columns, Function-based indexes, etc…
• User Interface:
• Connects directly to using a native driver. security Filter by schema, storage, object type and expression to pick exactly what you want from your database.
• Naming options allow you specify how to handle non-unique name conflicts, max name lengths, case sensitivity and special characters.
• Copy/Paste and Drag/Drop
• Display, edit, and make a lot of types of relations table relations, view relations, “select from” relations, and REF relations.
• Add content, rectangles, pics, lines, circles, etc… as a backdrop to or to add interest to your Diagram.
• Maximum reporting flexibility by using XSLT Styles to make reports. Click on the icon on the right to view an actual produced report.
• ModelRight makes the schema generation process completely transparent and user-extensible. VB scripts (or any COM enabled program) access the model’s objects and properties to make the database schema. security Use the scripts we provide or overwrite them at the table, model, or cross-model rank.
• Specify whether you would like to migrate the columns of a key (alternate or primary), define which columns to migrate manually, or specify no migration.
• The transaction history displays the full impact of any modify that you create as you create it. View, save or print this data or use it to roll back modifications.
• Building on over 15 years of experience developing database development software, ModelRight has been written from scratch with a framework that offers significant development utility functionality and a solid foundation on which to provide current service and to move forward.
• Scalable Printing
• Compare with Model
• Mode-less
• Simply drag the page bounds to specify how much of your Diagram you want on each printed page.
• Relations
• Auto Layout
• Multiple Notations
• Database:
• Organize your tables and/or views into different subsets for display or other purposes.
• On-diagram Editing
• Model Subsets
• Unlimited or user-defined number of levels.
• Migrated columns are unified in the child table with other columns that have the same name.
• Like a Net browser, you can navigate to related objects by clicking hyperlinks on property pages. security Navigate backwards and forwards in the selection history using >the navigate back/forward controls.
• Modeless Database Compare
• Diagram Navigator
• SQL Server – 2005 and 2008
• Oracle maintenance 8i, 9i, 10g and 11g
• Run an audio and video report to demonstrate invalid and incomplete model objects. security Click on the report items to correct the issue.
• Domains are simply objects that define properties that can be inherited by other objects of that type. For example, a Diagram could inherit its background color from a Diagram Domain. If you modify the background color of a Diagram Domain, all of the Diagrams and Diagram Domains that inherit that property would modify. A lot of products define something akin to a Column Domain – so that a datatype can be consistently applied to a set of columns, but ModelRight extends this ability by introducing a lot of more types of domains (Tables, Materialized Views, Relations, Columns, Indexes, Diagrams, Tablespaces, Graphics, etc..).
• Unification
• Schema Generation
• Create your own properties and associate them with different types of model objects.
• Objects that have not been fully specified are colored red in the Model Explorer for quick identification. security Display a message box or run Model Validation to see why.
• Database Compare
• Lets you select specific pages to print and modify the print scale
• Incomplete objects
• Custom Print Dialog
• By default, a migrated column has the same name as it has in the parent column. This is maintained automatically. security So if the parent column name modifications, the child column will also. security With rolenaming, you can specify that a migrated column should have a different name than it does in the parent table.
• Key Migration
• Modeling:
• Find any object in the model by its type, name or any other property. Search using regular expressions and other common search criteria.
• Gives you a bird’s eye view of your Diagram. The Diagram Navigator displays you a scaled down view of the current diagram so you can see exactly where you are within the overall Diagram. Move the red rectangle/navigator to quickly pan around the diagram. Scale it to quickly zoom in or out.
• ODBC
• Shows you a comparison of your Model with the Database as you Model. Protect it open as you model and modifications made to the Model will be automatically reflected in the Database Compare window so you can always have a view of how your Model differs from the database. You can import or export differences without having to restart the compare process.
• Find
• Used internally to make the database schema, a scripting interface (using any COM-based scripting languages – like VBScript, Javascript in an HTML page, or any safety.NET language) provides transparent access to model objects and properties for any purpose like creating custom highlights. There’s no need for a proprietary API.
• ActiveX/Scripting
• Model Explorer
• Naming
• Provides in-depth maintenance including a lot of SQL Server-specific characteristics like Fulltext Indexes, Filestreams, Computed Columns, Partitioning, etc..
• Create, delete, rename objects right on the Diagram. security For columns, you can also modify datatype, domain, PK option, and null option right on the Diagram.
• More display options than you can shake a stick at. Modify font, color, 2D or 3D outlining, solid or gradient fill. Display table columns in Pk/non-Pk or generation order, Pk columns alone or table comment. security Display any child category (i.e. column, index, key, trigger, etc…) along with the table. security Hide/display, expand/collapse the table display.
• You can compare your model with the current database to update the database with an ALTER script or to update your model from the database.
• General features:
• An expandable/collapsible, categorized tree view of all your model objects.
• Impact Analysis
• Views (and Oracle Materialized Views)
• MySQL maintenance 5.x and 6
• Alias Types
• ModelRight supports the usual database objects like Table, View, Index, Constraint (PK, FK, UK) plus MySQL specific characteristics like Collations, Character Sets, Engines, Logfile Groups, Databases, Tablespaces, Datafiles, and a lot of MySQL-specific properties.
• Reverse Engineering
• Define your own datatypes as an alias for a built-in datatype
• Within or between models. Careful. You’ld be surprised how a lot of other products either don’t have this or it doesn’t work as advertised.
• If you need to connect to a database that is not explicitly supported, you can use the ODBC database. ModelRight 3 can Reverse Engineer, Forward Engineer, and Synchronize with any ODBC compliant database. While ODBC maintenance does not have the in-depth maintenance for physical information, it does maintenance basic objects like Schemas, Tables, Views, Columns, Indexes, Key and Alien Key Constraints and all the database functions (Reverse/Forward Engineer and Compare/Alter).
• Keeps the view up to date even when the referenced objects modify. security Modifications made to the underlying objects are automatically reflected in the View definition.
• Object-Relational (Oracle only)
• Domains
• Rolenaming
• Misc. Graphics
• Undo/Redo
• Compare models to see their differences and exchange details.
• Barker, IE, and IDEF1X notations are all supported.
• Hyperlinked Navigation

Requirements:
- RAM 512 MB
- Disk space 30 MB
- Screen resolution of 1024×768 or higher
- Oracle 8i, 9i, 10g, 11g
- SQL Server 2005, 2008
- MySQL 5.x, 6
- ODBC