DataBasix 1.1

DataBasix 1.1 Screenshot DataBasix - use the power of XML to document, design, version-control and deploy your databases.

Developer:   BrandRock Software
      software by BrandRock Software →
Price:  499.00  buy →
License:   Shareware
File size:   0K
Language:   
OS:   Windows Vista (?)
Rating:   0 /5 (0 votes)

DataBasix - use the power of XML to document, design, version-control and deploy your databases. Think of it as creating source-code for your database. You design, edit and document the model as metadata away from the actual database catalogs. When the time comes to implement and test those changes, DataBasix generates the SQL DML/DDL code required to prepare the catalogs (development / test / production).

DataBasix features
  • Save time and effort by automatically generating upgrade scripts for your DBA. Simply load the old and new schema models and click the button.
  • Version control the structure of the database. The schema model is held in an XML text file, human-readable and suitable for source control repositories.
  • Version control the content of code / look-up / configuration tables. Store the DML statements used to INSERT, UPDATE or DELETE data in the target catalog(s). Generated upgrade scripts will ensure the tables contain the correct data. This could be crucial for the correct functioning of your application.
  • Run XPath queries on the schema. Useful for impact analysis (where-used), or design consistency (e.g. show all tables with no primary key)
  • Create custom schema reports, exports or even data-access code, in any text format (HTML/CSV etc.) using XSL transformations.
  • Extend the DBMS by adding custom properties and documentation on any structure, at any level. E.g. categorize tables by usage: lookup / transaction / master etc., add usage notes to indexes, etc.
  • Check any existing database catalog for compliance to the schema model. Find missing indexes, incorrect column lengths etc
  • Enforce design consistency. E.g. change in column length automatically updates all tables with such a column; delete column removes from table, indexes, foreign-keys etc.
  • Design at the metadata level, hands-off the database so as not to disturb the development team.
  • Collaborate and share your design as an XML document, with team members or other software.

    Limitations
  • Save file disabled

    tags version control  the schema  design consistency  all tables  tables with  the correct  schema model  control the  the database  for your  upgrade scripts  

    DataBasix 1.1 screenshot


    Download DataBasix 1.1

     Download DataBasix 1.1

    Purchase:  Buy DataBasix 1.1


    Similar software

    DataBasix 1.1 DataBasix 1.1
    BrandRock Software

    DataBasix - use the power of XML to document, design, version-control and deploy your databases.

    Copy Schema for SQL Server 1.08.00 Copy Schema for SQL Server 1.08.00
    OmBelt Solutions

    Copy Schema for SQL Server is an application for Microsoft SQL server that creates a copy for database objects definition: tables, views, triggers, indexes, primary and foreign keys, procedures, etc at the different database on the same or another server.

    Softinabox Script Engine 0.3.0 Build 52 (Beta 3) Softinabox Script Engine 0.3.0 Build 52 (Beta 3)
    Softinabox

    Softinabox Script Engine for Microsoft SQL Server 2000 is a powerful tool that enables you to document any existing database structure and/or data by generating one SQL script.

    Copy Schema for SQL Server Professional 1.02.00 Copy Schema for SQL Server Professional 1.02.00
    OmBelt Solutions

    Copy Schema for SQL Server is an application for Microsoft SQL server that creates a copy for database objects definition: tables, views, triggers, indexes, primary and foreign keys, procedures, etc at the different database on the same or another server.

    SQLDBCompare V2.4 SQLDBCompare V2.4
    Best SoftTool, Inc.

    SQLDBCompare is the powerful database schema comparison and synchronization application for SQL Server database development projects.

    DB Explorer 3.0.1 DB Explorer 3.0.1
    SLIK Software Ltd

    DBExplorer is a strong database tool which will allow you to compare any two databases and report the structural and/or data differences between them.

    DBISAM Script Wizard 1.0 DBISAM Script Wizard 1.0
    EZ Delphi

    DBISAM Script Wizard is a database schema script engine.

    Export Schema to SQL for SQL Server 1.08.00 Export Schema to SQL for SQL Server 1.08.00
    OmBelt Solutions

    This Export tool for Microsoft SQL server will create SQL script for datbase objects definitions: tables, views, triggers, indexes, primary and foreign keys, procedures, etc.

    SQL Admin Studio 3.0.3090 SQL Admin Studio 3.0.3090
    Simego

    SQL Admin Studio is a strong SQL Database Management program.

    dbConstructor 1.4.1.189 dbConstructor 1.4.1.189
    dbConstructor

    dbConstructor was developed with the main focus on speeding and easing the database schema creation and maintenance process, while maintaining the complete documentation and change management required in today's fast development environment.