View Issue Details

IDProjectCategoryView StatusLast Update
0004526SymmetricDSBugpublic2020-09-23 20:34
Reportercaokycuong@gmail.com Assigned Toelong  
Priorityhigh 
Status closedResolutionfixed 
Product Version3.12.3 
Target Version3.12.4Fixed in Version3.12.4 
Summary0004526: [dbcompare command] - Generate script wrongly
DescriptionWhen I use command [dbcompare] as below:

C:\Support\SyncData\symmetric-server-3.12.2\bin>dbcompare adlog_20200527.m_customer -s C:\Support\SyncData\symmetric-server-3.12.2\engines\adlog-000.properties -t C:\Support\SyncData\symmetric-server-3.12.2\engines\adlogDW-001.properties --target-tables so.m_customer --use-sym-config false
I use the tool dbcompare to compare 2 tables in different schema

The log file returns errors that the table does not exist.
I checked that the code generated to execute is:
select ... from "so.m_customer"
It does not work, it should be generated as "so"."m_customer"
Steps To ReproduceC:\Support\SyncData\symmetric-server-3.12.2\bin>dbcompare adlog_20200527.m_customer -s C:\Support\SyncData\symmetric-server-3.12.2\engines\adlog-000.properties -t C:\Support\SyncData\symmetric-server-3.12.2\engines\adlogDW-001.properties --target-tables so.m_customer --use-sym-config false

where:
adlog_20200527: source schema
so: target schema

DB: Oracle 11.2
Tagsdbcompare

Relationships

related to 0004522 closedelong DbCompare does not seem to support schema/database prefixed table names for at least the target node 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2020-09-07 01:27 caokycuong@gmail.com New Issue
2020-09-07 01:27 caokycuong@gmail.com Tag Attached: dbcompare
2020-09-16 17:42 elong Relationship added related to 0004522
2020-09-16 17:42 elong Assigned To => elong
2020-09-16 17:42 elong Status new => assigned
2020-09-16 17:43 elong Status assigned => resolved
2020-09-16 17:43 elong Resolution open => fixed
2020-09-16 17:43 elong Fixed in Version => 3.12.4
2020-09-16 17:43 elong Target Version => 3.12.4
2020-09-23 20:34 admin Status resolved => closed