Problems with schema compare option: "Compare sequence latest value"

[Ash]

Hi,

I'm using DBSolo v3.7.5 and trying to perform a schema compare using
the option: "Compare sequence latest value". Whilst the visual compare
results show that sequence values are different, when I try to
generate the sync script, it does not align the sequence values
correctly. It simply drops and re-creates each sequence.

Thanks.

[DB Solo]

This should be fixed now, please download the latest from dbsolo.com/preview.

marko

[Ash]

It now partially works i.e. sequence value is correctly synced only if
the sequence exists on both source and destination database. However,
if one database does not have the sequence then only a 'CREATE
SEQUENCE' sync script is generated without aligning the sequence value
(similar to the earlier version of db solo).

Thanks.

[DB Solo]

This should be fixed, the new sequence is created with 'START WITH x'
where x is set to the latest value of the original sequence.

Marko