Frequently Asked Questions
Frequently asked questions section will give you overview of most frequent questions to our support team. During the time, section will grow.How to compare database schemas?
In main application menu go to
"File-->New-->Schema Compare". You will get empty
"Schema Compare" window.
- Define data sources which
need to be compared
On "Action" menu choose "Connect" where you will get "Data Connection" dialog where you should choose your data sources which has to be compared. - Compare
On "Action" menu choose "Compare". Program will start comparing items. - Synchronize
As a very last step in comparing procedure is a sql script generation. You will be able to see on "SQL" tab synchronization script. By double clicking on arrow you can change direction of synchronization. Script shown underneath will change at the same time.
If you choose "Action"-->"Synchronize" application will start executing script defined for synchronization previously requesting confirmance of that action.
You can save script by simply pressing "Save" button on toolbar or chose "File"-->Save menu item.
How to compare data?
In main application menu go to
"File-->New-->Data Compare". You will get empty
"Data Compare" window.
- Define data sources which
need to be compared
On "Action" menu choose "Connect" where you will get "Data Connection" dialog where you should choose your data sources which has to be compared. - Compare
On "Action" menu choose "Compare". Program will start comparing items. - Synchronize
As a very last step in comparing procedure is a sql script generation. You will be able to see on "SQL" tab synchronization script.
If you choose "Action"-->"Synchronize" application will start executing script defined for synchronization previously requesting confirmance of that action.
You can save script by simply pressing "Save" button on toolbar or chose "File"-->Save menu item.
Does DBTyP.NET provides just cross database comparison?
No. DBTyP.NET has that advantage to compare a different DBMS but can be used for comparison and synchronization of same DBMS. This means, that with DBTyP.NET you can compare following:
SQL Server with SQL Server, MySQL with MySQL and SQLServer with MySQL.
Can I compare Oracle databases?
Partially yes. DBTyP.NET 2008 supports Oracle Data Comparison. Oracle Schema Comparison is a first thing to be released next.
What's comming next?
In next release DBTyP.NET will support DB2, selective Schema Synchronisation, command line comparison...







