WinSQL

Schema Diff Wizard

This feature helps you find schema differences between two databases. It creates a report in HTML format that can be viewed in any browser. Comparison is based on:

  • Table schema, including column names, datatypes, defaults, foreign keys, nullability and triggers
  • View columns and SQL script
  • Stored procedure columns and script
  • Database specific features like rules and custom datatypes

    FAQ about Schema-Diff

    Question: What is the format of the output report?
    Answer: The generated report is in HTML format.

    Question: Which type of databases are ideal for comparison?
    Answer: During the life-cycle of any project, engineers create multiple copies of the same database - one for development and other for production. Often these copies get out of sync as engineers modify the design to either optimize the database or add new features. The schema diff feature in WinSQL is ideal to compare such differences.

    Question: Can I compare databases of different types - meaning schema of an Oracle database with MS SQL Server?
    Answer: Threoritically, you can compare databases residing in two different RDBMS system. However, due to incompatibilities in certain database objects you will get several mismatch in the report. For example, if you try to compare an Oracle schema with Microsoft Access, you will get incompatibilities on data types such as TIMESTAMP.

    Question: How is the comparison performed?
    Answer: Schema-Diff comparison is a two-pass process. Initially, WinSQL selects one of the database as the reference database and checks if the other database has similar objects. This is the first pass. Next, WinSQL switches the reference database and compares the objects in the second database to the first one.

    This results in two reports - each with respect to a database.

    This feature makes WinSQL a perfect tool to compare differences between a development and production databases or when you are migrating data from one database to another.

    Screen Shots

    Screen to select the two databases


    Pick different options for comparison


    Uses cascading style sheets to specify format. This makes it very easy to change the output format


    Watch the status as WinSQL compares the objects

  • Navigation

    Social Media

    Powered by 10MinutesWeb.com