|
|
| Compare two database schemas and/or table data rows and report differences. Synchronise the differences for one or other database. Sync Schema generates the SQL DDL statements. Sync Data either transfers the rows or generates SQL DML statements. |
|
| Updated |
Jul 3, 2008 16:13:14 | | Size | 9205 kb | | Licence | Shareware | | Status | Major Update | | Languages | English | | Tags | database utility, compare database, view database, database difference, schema, metadata, compare tables, compare data, compare records, synchronise database | | OS | Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP | | Homepage | sliksoftware.co.nz | | Email | general@slik.co.nz | | Author | Chris Wenzlick |
|
|
 click for full size
|
| Other author's software: | - ODBC View 3.4.0 — ODBCView is a free SQL query tool to view and export data from any OBDC database. Data is displayed on a read-only grid and can be exported to a CSV or HTML report. Note, any valid SQL statements can be executed including SQL UPDATE and DELETE stmts.
| | Show all author's software |
Description:
DBExplorer is a powerful database utility that allows you to compare any two databases and report the structural and/or data differences between them. It then enables you to synchronize the differences. DBExplorer supports any OLE DB or ODBC compliant database which includes all the mainstream databases including MS SQL Server, Oracle, DB2, Access etc.
Database Catalog
Browse a databases schema and/or data. Provides a built in reporting tool and an export to file feature so you can document the database schema and records. An SQL query wizard allows you to select particular columns and filter specific records. It can also generate SQL DDL scripts to reproduce or record the database structure.
Compare Schema
Compare the structure or metadata between two versions of a database. The objects compared include tables, columns, views, procedures, indexes and foreign and primary keys constraints. Once the comparison is complete DBExplorer presents a detailed on-screen summary. From here DBExplorer can automatically generate the appropriate SQL statements (ie, SQL DDL - Data Definition Language) to bring the database up to date. Depending on the differences detected this may be a "CREATE TABLE/VIEW/PROCEDURE" or a "ALTER TABLE ADD COLUMN…" type statement. These generated SQL statement can be saved to a separate SQL script file for later execution or applied directly.
The entire comparison results can also be saved to a document file or printed out as a HTML report.
Compare Data
DBExplorer uses a sophisticated internal hashing algorithm to report the differences between the data stored in two databases. The databases to compare do not have to reside on the same machine or even in the same RDBM system. Comparison includes records that are identical, duplicated or having the same data but different keys as well as being present in only one of the databases.В Once the comparison is complete you can choose to synchronise selected records to one or other database. | Short tags:
database utility, compare database, view database, database difference, schema, metadata, compare tables, compare data, compare records, synchronise database | System Requirements:
Pentium 266 or better,128 MB RAM | Change Info:
Added columns difference and SQL DDL view |  Find last version of DB Explorer | |
| | Freeware alternatives DB Explorer 3.0.0 |
|  Free Download DB Explorer 3.0.0 from sliksoftware.co.nz |
| Similar software shotlights: | - SQLMerger 2.1 — SQLMerger enables you to compare and merge data from two databases visually and automatically. All the changes are made via a SQL script automatically created and collected through time. SQLMerger…
| | Find all software similar on DB Explorer 3.0.0 |
| Similar smart reviews: | - MX Skype Recorder - the easiest way to record your VoIP conversations — Broadband Internet access and the emergence of easy-to-use and high quality VoIP software made millions of users worldwide forget about conventional phones, especially when making long distance or international calls. IP telephony is cheaper, can be combined with video conferencing and generally provides more features people can make good use of. If you resort to VoIP calls quite often to discuss…
- i-Sound WMA MP3 Recorder 6.60, My small home recording studio. — Long time ago, in pre-digital era, we have only one, but really universal method to record any sound we ever can hear, named tape-recorder. The method was quite dumb, but very reliable: after pushing Record button it has recorded really *anything*. And what we have now, with our cool-almighty-smart-digital computers? Have you software, which can with record equal success: you voice; sound from internet-radio you are…
- Cool Record Edit Pro — If you were a music fan before the guys at Fraunhofer came up with their MP3 format, you are well aware what audio cassettes and vinyl disks are. And if your collection of old hits was of any value to you, your nostalgia definitely stopped you from getting rid of them once and forever, so it is probably stuck somewhere in your garage. However, if time has come…
- AirCorder. Broadcast Recorder. — You like listening to the radio but can not afford enjoying it because of the intensive job; you are looking forward to the week’s end to enjoy the broadcast or you want to have the latest music hits broadcasted over your favorite radio station on your PC but can not spend hours trying to record them all. No problem. AirCorder is all that you need. AirCorder…
- AlphaLand, Keep Property Records Organized — To make use of the power of high-tech in the property management business, it’s not enough to merely move data from a hardcopy to the digital format. If the data remains spread over a countless number of folders, every attempt to add a new field or alter the structure of the data can turn into a major pain. The way out of the trouble is organizing the…
- MiniCapture – flexible and functional screen recording software for everyone — Whether you are school teacher, a university professor, a group leader or even a regular guy who is looking for a way to explain the basics of computer literacy to your mom or girlfriend, you must be concerned with finding a decent tool to capture the content of your computer’s screen and create nice-looking tutorials. If that’s the case, take…
- Acoustic Labs Multitrack Recorder, Sing Me The Song — Some things shouldn’t change with the time. OK, in fact they should, but they are to become «the same thing, but better», not «the new thing». When your mind and your hands «remember» how to do something, you wouldn’t be too happy about teaching yourself to do the same thing a completely new way. The Acoustic Labs Multitrack Recorder shows the…
- Advanced Data Generator - quick and easy generation of test data for your database — Whenever you develop a database-driven application of any type, database modeling and creation are an integral part of the process. However, testing cannot be properly carried out without realistic database data — you don’t see how objects, text and other database elements are rendered on the page, you can’t see a full picture of your e-commerce store full of products and…
- PhoneSpy - a phone calls recording studio in your computer — Some situations require us to have a complete record of conversations with colleagues, partners or clients — no matter what the reason is. Recording phone calls can be useful for resolving support cases, protecting yourself in courts or safeguarding yourself from unexpected business situations. Although a great many of people would love to have such an opportunity, the…
| | Find all smart reviews similar on DB Explorer 3.0.0 |
|
