|
Popular Beetle is a data comparative application that supports various databases like Oracle,
SQLServer, DB2, MySQL, PostgreSQL, Access and etc. Popular Beetle supports the function of merging data, creating SQL when updating data,
exporting the data of table to file with XML format and exporting the compared result to Excel file with User-Friendly GUI.
Anyway, Popular Beetle can greatly enhance the efficiency of system development.
|
|
|
Main Functions
|
|
|
■ Compare data and schemas between different databases.
|
|
Find out the difference of database clear at a glance while the different place are in differnt colors.
Note: It can also compare the data between different database engine.
Available Database Engine: Oracle、SQLServer、DB2、MySQL、PostgreSQL、MSAccess、EXCEL file、CSV file and the database that is support by ODBC
The workload of validation after database migration reduces a lot
|
|
|
|
■ Compare data before and after updating
|
|
Do the test on validation before and after data update visually.
The efficiency of batch program test raises at least 50%
|
|
|
|
■ The database compare, edit or merge becomes visual.
|
|
Merge the different data at one time or one by one.
Edit data of one side while the reference data on the other side is changeless.
Create SQL statement automatically when updating the data, and execute the SQL after affirmation.
It is easily to develop, test or maintain the program!
|
|
|
|
■ Execute SQL statement and compare the results
|
|
Compare the necessary data taken by execution of SQL statement.
Provide the powerful support of compare large amount of data or the necessary data.
|
|
|
|
■ Backup the data to XML file for recovery
|
|
Backup the data of database to XML file.
Compare the backup data before recovery and recover the necessery data to database.
Simple for system recovery and retest！
|
|
|
|
■ Export the compare results to Excel file
|
|
Export parts or all of compare results to Excel file.
It is simple to edit the data of database by copy and paste from Excel file.
Modify the data or export the compare results FREELY and EASILY！！
|
|
