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.
On Wed, Aug 26, 2009 at 8:50 PM, Ash<aku...@gmail.com> wrote:
> 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.
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.
On Aug 27, 12:23 pm, DB Solo <mhant...@gmail.com> wrote:
> This should be fixed now, please download the latest from dbsolo.com/preview.
> marko
> On Wed, Aug 26, 2009 at 8:50 PM, Ash<aku...@gmail.com> wrote:
> > 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.
On Fri, Aug 28, 2009 at 2:25 AM, Ash<aku...@gmail.com> wrote:
> 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.
> On Aug 27, 12:23 pm, DB Solo <mhant...@gmail.com> wrote:
>> This should be fixed now, please download the latest from dbsolo.com/preview.
>> marko
>> On Wed, Aug 26, 2009 at 8:50 PM, Ash<aku...@gmail.com> wrote:
>> > 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.