Generate Data Models From SQL
WinTranslator Adds SQL Reengineering Generate Data Models From SQL For Popular RDBMS Products Excel Software extended the reengineering capabilities of WinTranslator to generate WinA&D data models from SQL code. Database designers can quickly generate logical and physical data models from an SQL schema for popular RDBMS products including Oracle, SQL Server, DB2, Sybase, Informix and InterBase. Rich data models can represent tables, views, constraints, assertions, triggers, indexes, procedures and other SQL elements. WinA&D is a comprehensive tool for system analysis, requirement specifications, software design and code generation. Popular modeling notations and supported methods include object-oriented analysis and design with UML, structured analysis and design using Yourdon/DeMarco and Information Engineering (Martin) style data models for developing information systems. WinTranslator is a reengineering tool for WinA&D that generates UML class models for C++, Java and Delphi and structure charts from C, Pascal, Basic and Fortran. WinTranslator processes an input SQL script file containing statements like CREATE TABLE, CREATE TRIGGER, etc. and produces a dictionary entry list that can be imported into WinA&D. The new WinA&D 3.2 software automatically generates data models from the dictionary information. Within minutes designers can view graphic data models to understand, communicate or enhance their database systems. Data models can be edited within WinA&D and used to generate new SQL schemas for a selected RDBMS. Data models can be integrated with other WinA&D models such as process models that show information flow or state models that show different modes of operation and event transitions. HTML reports can easily be generated to communicate models, specifications and requirements to anyone with a web browser. WinTranslator has a selection option for SQL-99, Oracle, SQL Server, DB2, Sybase, Informix or InterBase dialects of SQL. Vendor specific SQL statements in other dialects can also be supported with a configuration option that captures design data from the SQL script. Some RDBMS products support multiple schemas within a database. Each schema is automatically mapped to a different namespace within the WinA&D design environment. WinTranslator is priced at $495 and runs on Windows 95, 98, NT or 2000. Contact Excel Software for site license and upgrade prices or visit www.excelsoftware.com for information and online ordering. Excel Software Ph: (505) 771-3719 Fax: (505) 771-3718 Web: http://www.excelsoftware.com Email: info@excelsoftware.com