View Issue Details

IDProjectCategoryView StatusLast Update
0003213SymmetricDSImprovementpublic2017-08-14 14:43
Reportermmichalek Assigned Tommichalek  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.29 
Target Version3.8.29Fixed in Version3.8.29 
Summary0003213: dbcompare - support excluding individual columns from comparison
DescriptionTo configure this, first specify a config properties file on the command line (e.g. dbcompare --config ./db-compare.properties)

Use properties of this form to exclude columns:
[table_name.]exclude_columns=<column_name_1>[,column_name2...]

For example, to exclude to "cost" column from the item_selling_price table, you would specify:
item_selling_price.exclude_columns=cost

To exclude "last_update_time" and "created_time" columns on all tables, use:
exclude_columns=last_update_time,created_time

Note that table names and column names should be specified in lower case.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 0f4f46c3

2017-07-31 16:27:50

mmichalek

Details Diff
0003213: dbcompare - support excluding individual columns from
comparison
0003173: dbcompare - support overriden target table names.
Affected Issues
0003213
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/DbCompareCommand.java Diff File
mod - symmetric-client/src/main/resources/symmetric-messages.properties Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompare.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompareConfig.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/DbCompareTables.java Diff File

Issue History

Date Modified Username Field Change
2017-07-31 18:44 mmichalek New Issue
2017-07-31 18:44 mmichalek Status new => assigned
2017-07-31 18:44 mmichalek Assigned To => mmichalek
2017-07-31 20:33 mmichalek Status assigned => resolved
2017-07-31 20:33 mmichalek Resolution open => fixed
2017-07-31 20:33 mmichalek Fixed in Version => 3.8.29
2017-07-31 20:35 mmichalek Project SymmetricDS Pro => SymmetricDS
2017-07-31 21:00 mmichalek Changeset attached => SymmetricDS 3.8 0f4f46c3
2017-08-14 14:43 chenson Status resolved => closed