Do you need to design, visualize or document your database? ModelRight 3 for MySQL 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 MySQL database? ModelRight 3 has more complete and in-depth support for your MySQL's most advanced features. Plus, it has a modern user interface that allows for easy diagram editing and navigation.ModelRight 3 for MySQL 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 MySQL 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 for MySQL. Database modelling has never been more professional and easier! key features of "ModelRight":General features:ï؟ Undo/RedoUnlimited or user-defined number of levels.ï؟ Copy/Paste and Drag/DropWithin or between models. Careful. You'ld be surprised how many other products either don't have this or it doesn't work as advertised.ï؟ FindFind any object in the model by its type, name or any other property. Search using regular expressions and other common search criteria.ï؟ ReportingMaximum reporting flexibility by using XSLT Templates to generate reports. Click on the icon on the right to view an actual generated report.ï؟ Impact AnalysisThe 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 PrintingSimply drag the page bounds to specify how much of your Diagram you want on each printed page.ï؟ Custom Print DialogLets you select specific pages to print and change the print scaleï؟ Self-Validating FoundationBuilding 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/ScriptingUsed 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 ExplorerAn expandable/collapsible, categorized tree view of all your model objects.ï؟ Mode-lessOur 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 NavigationLike 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 OptionsMore 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 NavigatorGives 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 EditingCreate, 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. GraphicsAdd text, rectangles, images, lines, circles, etcï؟½ as a backdrop to or to add interest to your Diagram.ï؟ Multiple NotationsBarker, IE, and IDEF1X notations are all supported.ï؟ Auto LayoutAn expandable/collapsible, categorized tree view of all your model objects.Modeling:ï؟ DomainsDomains 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..).ï؟ RelationsDisplay, edit, and generate many types of relations - table relations, view relations, "select from" relations, and REF relations.ï؟ Compare with ModelCompare models to see their differences and exchange information.ï؟ NamingNaming options let you specify how to handle non-unique name conflicts, max name lengths, case sensitivity and special characters.ï؟ Model SubsetsOrganize your tables and/or views into different subsets for display or other purposes.ï؟ Key MigrationSpecify whether you would like to migrate the columns of a key (alternate or primary), define which columns to migrate manually, or specify no migration.ï؟ UnificationMigrated columns are unified in the child table with other columns that have the same name.ï؟ RolenamingBy 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 PropertiesCreate your own properties and associate them with different types of model objects.ï؟ Model ValidationRun an interactive report to show invalid and incomplete model objects. Click on the report items to correct the issue.ï؟ Incomplete objectsObjects 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 TypesDefine your own datatypes as an alias for a built-in datatype Database:ï؟ Schema GenerationModelRight 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 generate the database schema. Use the scripts we provide or overwrite them at the table, model, or cross-model level.ï؟ Reverse EngineeringConnects directly to using a native driver. Filter by schema, storage, object type and expression to pick exactly what you want from your database.ï؟ Database CompareYou can compare your model with the current database to update the database with an ALTER script or to update your model from the database.ï؟ Modeless Database CompareShows you a comparison of your Model with the Database as you Model. Keep it open as you model and changes 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. ï؟ Oracle support - 8i, 9i, 10g and 11gModelRight supports the usual database objects like Table, View, Index, Constraint (PK, FK, UK) and Oracle specific features 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ï؟½ï؟ SQL Server ï؟½ 2005 and 2008Provides in-depth support - including many SQL Server-specific features like Fulltext Indexes, Filestreams, Computed Columns, Partitioning, etc.. ï؟ MySQL support - 5.x and 6ModelRight supports the usual database objects like Table, View, Index, Constraint (PK, FK, UK) - plus MySQL specific features like Collations, Character Sets, Engines, Logfile Groups, Databases, Tablespaces, Datafiles, and many MySQL-specific properties. ï؟ ODBCIf 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 support does not have the in-depth support for physical details, it does support basic objects like Schemas, Tables, Views, Columns, Indexes, Key and Foreign Key Constraints and all the database functions (Reverse/Forward Engineer and Compare/Alter). ï؟ Object-Relational (Oracle only)Create new Types, attributes, object tables, object views, etcï؟½ï؟ Views (and Oracle Materialized Views)Keeps the view up to date even when the referenced objects change. Changes made to the underlying objects are automatically reflected in the View definition. Requirements:
· RAM 512 MB
· Disk space 30 MB
· Screen resolution of 1024x768 or higher
· Oracle 8i, 9i, 10g, 11g
· SQL Server 2005, 2008
· MySQL 5.x, 6
· ODBC
Limitations:
· 30 days trial
· Nag screen What's New in This Release: [ read full changelog ]
· misc fixes as noted in support tracking system
|