TMS Data Modeler The ultimate tool for modeling databases with an easy and simple interface. TMS Data Modeler is the ultimate tool for modeling databases with an easy and simple interface. Oracle 10g; PostgreSQL; SQLite; thank advance.
TMS Data Modeler is the ultimate tool for modeling databases with an easy and simple interface. It provides powerful features you need, such as diagramming, reverse engineering, SQL script generation and version control. It keeps track of your changes and generates SQL scripts to update your database according to them. It has smooth integration with development tools like Delphi and C++Builder. And all of these features are accessible through a very pleasant user interface. Feature Overview Design your database model • • • • • • • Database development lifecycle • • • • • • • Simple and easy • • • • • Supported databases • Absolute Database • ElevateDB • Firebird 2 • MS SQL Server 2000 • MS SQL Server 2005 • MS SQL Server 2008 • MS SQL Azure • MySQL 5.1 • NexusDB V3 • Oracle 10g • PostgreSQL • SQLite 3.7 Features Entity relationship diagram editor (ER diagram) Design ER diagrams using Data Modeler. You can add tables to the diagram, see the relationships, change several display options, and much more.
Create tables in diagram and/or in tab forms If you don't want or don't need to model your database using diagrams, you don't have to. Data Modeler allows you to create and manage database objects directly, without having to deal with visual diagram designing. It's up to you. Multi-diagram interface Create different ER diagrams in a single project. You can put different tables in each diagram, making it easy to document and separate your application if it's too big.
Project validation allows you to trace errors in your model Data Modeler performs a validation in your database model checking for design errors. It also displays warnings about your project, such as usage of reserved words and tables with no primary keys, among others. This validation allows fine tuning of your database model, and avoids future problems after your software is in production. Supports logical (application-level) domains Use domains as an abstraction layer for your data types. Even if your database system doesn't support domains/user-defined types, you can do it at application level in Data Modeler and make it easy to maintain your databases. Manage many database objects You can use Data Modeler to manage not only tables and fields, but several other database objects.
Data Modeler supports indexes, triggers, relationships, constraints, views, procedures, generators, etc. Each database system has its own set of objects available. Several database systems supported and more will be added Data Modeler supports a number of database systems and new ones are in our roadmap to be included in future versions. Reverse engineering of existing databases Import your existing databases and start using Data Modeler quickly.