Depending on the differences detected this may be a "CREATE TABLE/VIEW/PROCEDURE" or a "ALTER TABLE ADD COLUMN?" type statement. From here DBExplorer can automatically generate the appropriate SQL statements (ie, SQL DDL - Data Definition Language) to bring the database up to date. Once the comparison is complete DBExplorer presents a detailed on-screen summary. The objects compared include tables, columns, views, procedures, indexes and foreign and primary keys constraints. It can also generate SQL DDL scripts to reproduce or record the database structure.Ĭompare the structure or metadata between two versions of a database. An SQL query wizard allows you to select particular columns and filter specific records. Provides a built in reporting tool and an export to file feature so you can document the database schema and records. DBExplorer supports any OLE DB or ODBC compliant database which includes all the mainstream databases including MS SQL Server, Oracle, DB2, Access etc.īrowse a databases schema and/or data. It then enables you to synchronize the differences. DBExplorer is a powerful database utility that allows you to compare any two databases and report the structural and/or data differences between them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |