Tms Data Modeler V3.3.4 ((free)) Full Source -
TMS Data Modeler V3.3.4 a specialized database modeling and design tool from TMS Software
that streamlines the database development lifecycle through visual diagramming and automated code generation
. Released in August 2019, version 3.3.4 specifically focused on enhancing PostgreSQL support by adding range types like Core Functionality
TMS Data Modeler serves as a central environment for managing database structures independently of the specific database management system (DBMS) being used. Its primary capabilities include: Visual ER Diagramming
: Create and manipulate tables, relationships, and other database objects like triggers and views using a modern ribbon interface. Reverse Engineering
: Import the structure of an existing database to generate a visual model, which is helpful for documenting legacy systems. SQL Script Generation
: Automatically generate clean DDL scripts to create new databases or "Alter" scripts to update existing structures while preserving data. Version Control
: Track changes to models over time, allowing for comparison between different versions or separate projects. Delphi and C++Builder Integration
A standout feature of the tool is its deep integration with Embarcadero development environments. It allows developers to: Generate Delphi/C++Builder Classes
: Automatically export database models as mapped classes for use with TMS Aurelius , a popular Object-Relational Mapping (ORM) framework. Customizable Output
: Version 3 introduced a scripting system that allows users to fully customize the generated source code, reducing the need for manual edits. Multi-Platform Support
: Targeted code can be used for Win32, Win64, macOS, VCL, and FireMonkey applications. Licensing and Source Code TMS Software typically provides the Full Source Code
of its components to licensed users for modification and internal use. Key licensing points from the TMS Single Developer License Modification Rights
: Licensed developers can modify the source code for their own use. Distribution Constraints
: While you can sell commercial applications built with the tool, you are strictly prohibited from distributing the original or modified source code of the component itself. Support & Updates
: Licenses generally include access to future versions until the registration expires. Version 3.3.4 Specifications Release Date August 2019 Key Improvement Support for PostgreSQL range types Supported Databases
SQL Server, Firebird, MySQL, Oracle, PostgreSQL, DB2, and more Interface Style Microsoft Office 2010 style with a modern ribbon TMS Aurelius for ORM mapping? TMS Data Modeler - TMS Software
TMS Data Modeler is a database modeling and design tool primarily used by Delphi and C++Builder developers to design ER diagrams, generate SQL scripts, and manage database versioning
. The "Full Source" version is generally available through specific TMS Software licensing tiers, such as the TMS BIZ Standard TMS Software Key Features of Version 3.3.4
Version 3.3.4 and its subsequent updates (like 3.4) focused on enhancing script customization and integration with the TMS Aurelius ORM. TMSSoftware Aurelius Integration TMS Data Modeler V3.3.4 Full Source
: Specialized export options allow for automatic generation of Delphi source code (entity classes) from the data model, including support for static methods and fields. Reverse Engineering
: Import the structure of existing databases into a visual diagram. Version Control
: Tracks changes to the model and generates incremental SQL "alter" scripts to update existing databases. Multi-DBMS Support
: Independently model databases for various systems including MS SQL Server PostgreSQL Diagramming
: Visual representation of entity-relationship diagrams (ERD) with a clean, single-window interface. TMS Software Licensing & Full Source Availability
TMS Data Modeler is distributed under several commercial licenses. The "Full Source" typically refers to the native Pascal/Delphi source code
of the libraries, allowing developers to customize or debug the integration within their own IDE. TMS Software TMS BIZ Standard/Premium
: Includes the full source code for Data Modeler and other "Biz" components. TMS ALL-ACCESS
: A comprehensive subscription providing access to all TMS products, including full source code versions. TMS Software Technical Specifications : Integrates with Delphi and C++Builder Supported Databases
: Absolute Database, ElevateDB, Firebird 2/3, MS SQL Server (various versions), MS SQL Azure, MySQL 5.1/5.7, NexusDB V3, Oracle 10g, PostgreSQL, and SQLite. Library (DMLib)
TMS Data Modeler is a professional visual database design system developed by TMS Software that integrates modeling, creation, and maintenance into a single environment. The software is specifically designed to streamline the lifecycle of a database, from initial conceptual design to long-term structural updates. Core Capabilities
Database Modeling & Design: Users can visually create Entity-Relationship (ER) diagrams, adding tables and defining fields through an intuitive interface.
Reverse Engineering: The tool can import the structure of an existing database to generate a visual model, allowing developers to document or modify legacy systems.
SQL Script Generation: It generates clean DDL SQL scripts to create new databases or "Alter" scripts to update existing structures based on model changes.
Version Control: Integrated version management allows developers to archive versions of a database model and compare changes over time.
Multi-DBMS Support: It is optimized for major systems including Microsoft SQL Server, Firebird, Oracle, and MySQL. The Significance of "Full Source"
In the context of TMS Software products, the "Full Source" version refers to the commercial license that includes the complete Delphi source code.
Binary Compatibility: Unlike trial versions, which may have binary compatibility restrictions when used with other components, the full source version allows developers to compile the code directly into their applications.
Customization: Having the full source enables deep integration and the ability to customize the modeling engine or script generation to meet specific project needs. TMS Data Modeler V3
Delphi Integration: It integrates closely with the TMS Aurelius ORM, allowing for the automatic generation of Delphi entity classes directly from the database model. Strategic Value
By centralizing database information into a single project file, TMS Data Modeler serves as a "living document" that evolves with business needs. It helps prevent common design errors through Project Validation, which checks for missing primary keys or the use of reserved words before a system goes into production. This efficiency is furthered by its ability to convert models from one DBMS to another, ensuring flexibility across different server environments. TMS Data Modeler Documentation
TMS Data Modeler V3.3.4 is a robust database modeling tool designed to streamline the design, maintenance, and creation of databases across multiple platforms. The Full Source
version is particularly valuable for developers who need deep integration and customization, as it provides the complete underlying code used to build the modeler's core functionalities. Key Features of V3.3.4 Multi-Platform Support : Works with a wide range of databases including Oracle, MySQL, MS SQL Server, Firebird, and NexusDB Reverse Engineering
: Quickly import existing database structures to extract tables, fields, foreign keys, and other objects into a visual model. SQL Script Generation
: Automatically generate DDL scripts to create new database objects or update scripts to sync existing databases with your model changes. TMS Aurelius Integration : Direct export of classes for the TMS Aurelius ORM
framework, allowing you to bridge the gap between database design and Delphi application code. Version Control & Archiving
: Built-in system to track changes, manage different project versions, and add checkpoints as your data model evolves. User Interface
: Features a modern ribbon-style interface with a single-window design, making it easy to manage multiple projects without clutter. Benefits of the Full Source Edition Customization : Modify the internal logic of the modeler or the Aurelius export scripts to perfectly match your team's coding standards. Security & Compliance
: Audit the code internally for security requirements before deployment in high-stakes environments. Learning & Extension
: Use the source code as a reference for advanced database manipulation techniques in your own Delphi or C++Builder projects. Full Source license is typically included in
Here’s a strong feature highlight for TMS Data Modeler V3.3.4 Full Source, focusing on what makes it valuable for developers, architects, and teams working with database design.
3. Comprehensive Script Generation
Out of the box, V3.3.4 generates SQL DDL (Data Definition Language) scripts for:
- InterBase / Firebird (including dialect 3)
- MySQL / MariaDB
- Microsoft SQL Server (2000 through 2016)
- Oracle (9i through 12c)
- SQLite
- PostgreSQL
Each generator respects the specific quirks of that database (e.g., auto-increment via IDENTITY vs. SEQUENCE vs. AUTO_INCREMENT).
3.3 Code Generation (ORM Integration)
This is the standout feature for Delphi developers. V3.3.4 is engineered to output source code rather than just SQL.
- TMS Aurelius Support: It generates Delphi classes (Entities) with the correct Attributes (mapping decorators) required by the TMS Aurelius ORM framework.
- Automation: Reduces the boilerplate code required to map a database table to an Object Pascal class.
Reporting and Documentation
Produce professional database documentation without manual writing:
- Data dictionary (Table/Column descriptions)
- Relationship matrices
- Physical model reports
📦 Bottom Line
TMS Data Modeler V3.3.4 Full Source is not just a diagram tool – it’s a database development platform you can own, modify, and automate. Perfect for teams needing cross-database modeling without subscription clouds or binary-only black boxes.
“Design once. Generate everywhere. Keep the source.”
Would you like a comparison table vs. ER/Studio or dbForge Studio, or a sample script showing reverse engineering from an existing database? InterBase / Firebird (including dialect 3) MySQL /
TMS Data Modeler V3.3.4 introduced key enhancements to its database modeling capabilities, specifically for PostgreSQL and domain management. Key Features in V3.3.4
PostgreSQL Range Type Support: Added support for PostgreSQL-specific range types, including daterange and int4range.
Granular "Not Null" Control: A new "Specific" checkbox for the "Not null" field allows you to explicitly override domain settings. When a field is associated with a domain, this checkbox lets you choose whether to use the domain's NOT NULL flag or ignore it to use a custom value for that specific field. General Core Features
As part of the wider Version 3 series, this release also includes:
Entity Relationship (ER) Diagramming: A visual editor to design database models, which can be organized into multiple diagrams within a single project.
Reverse Engineering: Connect directly to existing databases (like SQL Server, Firebird, and Oracle) to extract tables, fields, and foreign keys.
TMS Aurelius Source Code Generation: Automatically generate Delphi source code with mapped classes for the TMS Aurelius ORM. This includes a customization script engine to tweak the output via event handlers.
Database Comparison & Versioning: Tools to compare project versions or two different projects, with the ability to generate Alter SQL scripts to update existing database structures.
Modern Ribbon Interface: An Office-style interface designed for quick navigation and ease of use, with objects organized into tabs. TMS Data Modeler - TMS Software
TMS Data Modeler: Professional Database Design and source generation
TMS Data Modeler is a comprehensive visual design system for database modeling, creation, and maintenance. It is specifically optimized for developers using Delphi and C++Builder, offering a bridge between physical database structures and application source code through automated class generation. Core Capabilities of TMS Data Modeler
The tool focuses on the entire database development lifecycle, from initial concept to versioned updates.
Entity-Relationship (ER) Diagramming: Users can design databases from scratch using a visual interface to create tables, fields, and relationships.
Reverse Engineering: Import structures from existing databases to visualize or modify them.
SQL Script Generation: Automatically generate clean DDL scripts for creating new databases or updating existing ones based on model changes.
Version Control: Track changes to your database model over time, allowing for the archival and comparison of different versions.
Cross-Platform Conversion: Easily convert a project designed for one DBMS (like SQL Server) to another (like PostgreSQL or SQLite). Advanced Source Code Generation
One of the standout features of TMS Data Modeler is its integration with the TMS Aurelius ORM. TMS Data Modeler Documentation
7. Version-Control Friendly
Models stored as text-based XML files – not binary.
✅ Diff in Git, merge branches, review changes in any text diff tool.