TMS Data Modeler is a visual database design system created by TMS Software that integrates design, modeling, and maintenance into a single environment. It is primarily used by developers to manage the entire lifecycle of a database, from initial conceptual design to live maintenance. Key Features and Capabilities
Database Modeling: Create tables, fields, indexes, triggers, and procedures through a visual interface.
Entity-Relationship (ER) Diagrams: Design complex models using visual diagrams with customizable display options.
Reverse Engineering: Import the structure of existing databases to create a visual model and documentation.
SQL Script Generation: Automatically generate clean DDL scripts for creating or updating databases.
Multi-DBMS Support: Supports major systems including Microsoft SQL Server, Oracle, MySQL, Firebird, and NexusDB. TMS Data Modeler V3.3.4 Full Source
Version Control: Track changes to your model and generate "alter" scripts to keep the production database in sync with your design. Integration and Development Benefits
Delphi and C++Builder Integration: Offers smooth integration with standard Embarcadero development tools.
TMS Aurelius Export: A significant feature for Delphi developers is the ability to generate TMS Aurelius classes directly from the database model, facilitating Object-Relational Mapping (ORM).
Project Validation: Automatically checks models for design errors, such as missing primary keys or the use of reserved words, to prevent production issues.
Modern UI: Uses a ribbon-based interface and tabbed editors (similar to web browsers) for easier navigation and object management. Core Operations for Developers TMS Data Modeler is a visual database design
Project Creation: Start new projects or import existing ones via Reverse Engineering.
Schema Comparison: Use the built-in comparer to identify differences between your model and a live database.
Database Conversion: Convert an existing model from one DBMS (e.g., SQL Server) to another (e.g., MySQL) with automatic data type mapping. TMS Data Modeler Documentation
The most critical part of this keyword is "Full Source." In the commercial software world, 99% of tools are delivered as compiled executables (EXEs) or DLLs. When you buy TMS Data Modeler as a standard binary, you get a tool you use.
When you acquire TMS Data Modeler V3.3.4 Full Source, you get the entire Pascal codebase of the application itself. The Crown Jewel: "Full Source" Explained The most
Teams writing their own Object-Relational Mapping (ORM) framework often need to generate metadata. The full source allows them to extract the model’s internal AST (Abstract Syntax Tree) directly.
While newer versions may exist, V3.3.4 serves as a stable, mature iteration of the software. It typically corresponds with the era of Delphi 10.4 Sydney or Delphi 11 Alexandria compatibility. It focuses on reliability in reverse engineering complex legacy databases and generating code for modern ORM frameworks.
For ISVs (Independent Software Vendors) building a database design tool into their own product suite, the full source license allows you to:
Even though V3.3.4 predates modern CI/CD buzzwords, clever developers have integrated it into pipelines:
DMC.exe). You can call this from a batch script..tmd model file, iterates through tables, and automatically adds CreatedDate and ModifiedDate columns via source modification..tmd XML format can be diffed. With full source, you can write a custom export tool that converts the model to plain text for version control.Financial, healthcare, and government sectors often require code audits. Having the full source allows your security team to scan every line of TMS Data Modeler for vulnerabilities or backdoors—something impossible with closed-source binaries.