Data Compare Comments

Matthew

unread,

Oct 7, 2009, 8:36:27 PM10/7/09

to DB Solo

Hi,

Setting the "datacomp_sync_comments" element to false in a data
compare project doesn't appear to work.

Matt

DB Solo Admin

unread,

Oct 7, 2009, 8:39:32 PM10/7/09

to DB Solo

Hi,

Can you provide an example that would demonstrate this issue (e.g.
CREATE TABLE script on both sides)? Also, what database are you using?

Marko

Matthew

unread,

Oct 7, 2009, 8:45:32 PM10/7/09

to DB Solo

The problem is with the data compare, not schema compare. With
datacomp_sync_comments set to false, the following is produced:

--
-- Generated by DB Solo 3.7.4 on Thu Oct 08 10:34:46 EST 2009
-- This script will modify the SOURCE database to be in sync with the
destination database
-- Source: [DB1] [S_OWNER]
-- Destination: [DB2] [S_OWNER]
--

UPDATE "S_OWNER"."UI_RESOURCE" SET "VERSION" = TO_DATE('2009-10-7
17:57:24','YYYY-MM-DD HH24:MI:SS') WHERE "ID" = 3;

We are using Oracle databases.

DB Solo Admin

unread,

Oct 7, 2009, 9:34:21 PM10/7/09

to DB Solo

This should be fixed now, please download the new version from
dbsolo.com/preview. Also, this can now be modified in the UI on the
Sync Script Options screen.

Marko

Matthew

unread,

Oct 7, 2009, 10:54:28 PM10/7/09

to DB Solo

Thank-you, this works now.

Matt

Reply all

Reply to author

Forward