|
|
descripton about Tabdiff
Compare Oracle Tables generate Upd-Ins-Del SQL Scripts to synchronize Table Data
GPL open source
sojasprosse@users.sourceforge.net
http://sourceforge.net/projects/Tabdiff/
Home
of Tabdiff V 1.0
Index of contents
Tabdiff is a software to compare the data rows of two Oracle Tables. It generates a Report Table in the Tabdiff schema that shows the different data rows between a source and a destination Table. The source and destination Table do not have to be identical, only column(s) which have the same names in both tables are considered during compare. Also the Table columns do not have to match in data type.
Tabdiff can generate a update-insert-delete SQL Script, to update-insert-delete the rows in the destination Table with rows from the report Table. Tabdiff can undo these changes again by generate a undo update-insert-delete script. The Destination Table has to be in the same Database as the Tabdiff schema, the source table can be in a another (remote) Database in this case you have to use a Database link to the source Table. Tabdiff has many other features for copying (synchronizing) data from one table to another.
If flag h and k is not used Tabdiff will update-insert-delete the destination Table direct with the rows from the source Table. In this case no Report Table is needed. becarefule with this option and always make shure you have made a backup.
It can exclude columns from update insert or compare. It can ignore NULL values in source table this has the effect that NULL values in the source table are not considered as differences and are not propagated to the destination. Tabdiff requires Oracle 9.x or lower database (does not work with Oracle 10x and 11x), the Oracle Client must be installed. It creates a table space and a schema Tabdiff with two PL-SQL Packages in the Oracle Database.
Tabdiff
requieres the following
additional Software
Oracle
9x or lower Client has to be installed
Tabdiff binary and source file download:
https://sourceforge.net/projects/tabdiffExtract the Tabdiff
setup folder to your workstation and
follow the Installtion steps as described in the Help File
Tabdiff.HLP
Tabdiff is available as GPL Open Source Licence.
For additional used components
you have to check License agreement!
The user has to take response to do this by himself!
Limitation see
capter DISCLAIMER in the helpfile Tabdiff.HLP
Download of the Tabdiff Source Code https://sourceforge.net/projects/tabdiff
Tabdiff was build Borland Delphi 5 for more details see Help file Tabdiff.HLP