ModelRight for SQL Server
Developer’s Description
Here are just a few of the features that ModelRight provides:
– Detailed Reverse Engineer of your existing database to visualize and document it.
– Generate the DDL for your entire database with the click of a button
– Compare your ModelRight model with your database.
– Push changes to the database with automatically generated ALTER statements. Import changes from the database to keep your model up to date.
– Compare Models to keep different versions or use one as a “Library Model” or “Data Dictionary”.
– Document your database with richly formatted notes, definitions, comments, and revision notes.
– Transparent access to any Model information via XML, ActiveX scripting, or reports.
– Generate HTML reports containing any Model information and linked images of your Diagrams.
– Use ModelRight to switch your schema from one database to another.
– Innovative User-Interface unlike any other data modeling tool in the market. Supports on-Diagram display and editing of any type of object and any property in any order.
– Break up a large model into subsets and have ModelRight automatically maintain them.
– Supports large, complex data modeling and data warehousing projects.
– Web-like hyperlinks provide an easy way to navigate to related objects.
– Customer-focused, Award-Winning Technical Support.
ModelRight for SQL Server 3.0.0 Build 83 Description:
Do you need to design, 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, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design 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 support for SQL Server’s most advanced features. Plus, it has a modern user interface that allows for easy diagram editing and navigation.
ModelRight 3 for SQL Server provides all of these powerful features (and many more) to help you produce the most complete and efficient database designs possible.
Whether you are a beginner or an expert database modeler, ModelRight 3 for SQL Server is your answer when you need a database modeling tool 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 professional and easier!
ModelRight for SQL Server 3.0.0 Build 83 Features:
General features:
· Undo/Redo
Unlimited or user-defined number of levels.
· Copy/Paste and Drag/Drop
Within or between models. Careful. You’ld be surprised how many other products either don’t have this or it doesn’t work as advertised.
· Find
Find any object in the model by its type, name or any other property. Search using regular expressions and other common search criteria.
· Reporting
Maximum reporting flexibility by using XSLT Templates to generate reports. Click on the icon on the right to view an actual generated report.
· Impact Analysis
The transaction history shows the full impact of any change that you make as you make it. View, save or print this info or use it to roll back changes.
· Scalable Printing
Simply drag the page bounds to specify how much of your Diagram you want on each printed page.
· Custom Print Dialog
Lets you select specific pages to print and change the print scale
· Self-Validating Foundation
Building on over 15 years of experience developing database design software, ModelRight has been written from scratch with a framework that offers significant design tool functionality and a solid foundation on which to provide current service and to move forward.
· ActiveX/Scripting
Used internally to generate the database schema, a scripting interface (using any COM-based scripting languages – like VBScript, Javascript in an HTML page, or any .NET language) provides transparent access to model objects and properties for any purpose – like creating custom features. There’s no need for a proprietary API.
User Interface:
· Model Explorer
An expandable/collapsible, categorized tree view of all your model objects.
· Mode-less
Our innovative mode-less style of interaction is simple and intuitive. 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 make changes.
· Hyperlinked Navigation
Like a Web browser, you can navigate to related objects by clicking hyperlinks on property pages. Navigate backwards and forwards in the selection history using >the navigate back/forward controls.
· Display Options
More display options than you can shake a stick at. Change font, color, 2D or 3D outlining, solid or gradient fill. Display table columns in Pk/non-Pk or generation order, Pk columns only or table comment. Display any child category (i.e. column, index, key, trigger, etc-) along with the table. Hide/display, expand/collapse the table display.
· Diagram Navigator
Gives you a bird’s eye view of your Diagram. The Diagram Navigator shows 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.
· On-diagram Editing
Create, delete, rename objects right on the Diagram. For columns, you can also change datatype, domain, PK option, and null option right on the Diagram.
· Misc. Graphics
Add text, rectangles, images, lines, circles, etc- as a backdrop to or to add interest to your Diagram.
· Multiple Notations
Barker, IE, and IDEF1X notations are all supported.
· Auto Layout
An expandable/collapsible, categorized tree view of all your model objects.
Modeling:
· Domains
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 change the background color of a Diagram Domain, all of the Diagrams and Diagram Domains that inherit that property would change. Many 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 capability by introducing many more types of domains (Tables, Materialized Views, Relations, Columns, Indexes, Diagrams, Tablespaces, Graphics, etc..).
· Relations
Display, edit, and generate many types of relations – table relations, view relations, “select from” relations, and REF relations.
· Compare with Model
Compare models to see their differences and exchange information.
· Naming
Naming options let you specify how to handle non-unique name conflicts, max name lengths, case sensitivity and special characters.
· Model Subsets
Organize your tables and/or views into different subsets for display or other purposes.
· Key Migration
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.
· Unification
Migrated columns are unified in the child table with other columns that have the same name.
· Rolenaming
By default, a migrated column has the same name as it has in the parent column. This is maintained automatically. So if the parent column name changes, the child column will also. With rolenaming, you can specify that a migrated column should have a different name than it does in the parent table.
· User-defined Properties
Create your own properties and associate them with different types of model objects.
· Model Validation
Run an interactive report to show invalid and incomplete model objects. Click on the report items to correct the issue.
· Incomplete objects
Objects that have not been fully specified are colored red in the Model Explorer for quick identification. Display a message box or run Model Validation to see why.
· Alias Types
Do you need to design, visualize or document your database?
ModelRight 3 can reverse engineer your existing database to get a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design up to date.
Do you need to control the most detailed aspects of your physical database?
Do you need to control the most detailed aspects of your physical database? ModelRight 3 has more complete and in-depth support for your database.ModelRight 3 has more complete and in-depth support for your database’s (currently Oracle, SQL Server, MySQL, and database via ODBC) most advanced features. Plus, it has a sophisticated modern user interface that allows for easy diagram editing and navigation.
ModelRight 3 provides all of these powerful features (and many more) to help you produce the most complete and efficient database designs possible.
Whether you are a beginner or an expert database modeler, ModelRight 3 is your answer when you need a database modeling tool that surpasses the “least common denominator” approach taken by others.
Try yourself and download ModelRight 3. Data Modeling has never been easier or more professional!
ModelRight can you help to create a new database application or manage an existing database. It will help you to visualize and manage the complexity of your database and create a solid database design.
If you have an existing database, ModelRight 3 can Reverse Engineer it to give you a graphical view of it. You can then use our Database Compare feature to display changes that you’ve made in your model and to push those changes to the database via ALTER scripts.
If you want to create a new database, you can create it graphically with ModelRight – and then automatically generate the necessary SQL DDL.
Various User Interface windows work together to provide an intuitive and natural design environment. With a mode-less and hyperlinked user interface, editing and navigating the data model is intuitive and easy.
You wouldn’t want to have to endlessly pop up dialogs to edit a document, so why would you want to edit your data model that way? With ModelRight, you don’t have to. Simply select the object you want to edit and change its properties in the Property Browser. Its a common User-Interface design that provides better overall ease of use, but only ModelRight makes it available in a data modeling tool.
And with unlimited Undo, you don’t need to worry about making a mistake – you can always undo it. Use the Transaction History window to view the full impact of any changes you make.
The Diagram drawing capabilities are advanced and full featured – allowing you to make your models look great!
The license of this software is Free Trial Software, the price is $895.00, you can free download and get a free trial.
Whether you are a beginner or an expert database modeler, ModelRight 3 for SQL Server is your answer when you need a database modeling tool that surpasses the “least common denominator” approach taken by others.
ModelRight 3 for SQL Server Publisher’s Description
ModelRight 3 for SQL Server can reverse engineer your existing SQL Server database to get a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design 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 support for SQL Server’s most advanced features. Plus, it has a modern user interface that allows for easy diagram editing and navigation.
ModelRight 3 for SQL Server provides all of these powerful features (and many more) to help you produce the most complete and efficient database designs possible.
Whether you are a beginner or an expert database modeler, ModelRight 3 for SQL Server is your answer when you need a database modeling tool that surpasses the “least common denominator” approach taken by others.
Try yourself and download ModelRight 3 for SQL Server. Data Modeling has never been easier or more professional!