Toad World® Forums

Issue with bigint identity in generate change script differencing

Hi,

When doing a Model -> Generate Change Script and comparing from the model to a sql server 2008 database, the reverse engineering of the sql db does not seem to be able to detect the increment and seed values of a bigint identity primary key field. I have them set at 1,1 in the model and in the database (verified in SSMS table design page), but in the differences window they show as blank on the sql db side and therefore as a difference.

Is this enough info to reproduce?

Also, to confirm, int identity primary key fields work fine i.e. increment and seed are recognised on the sql db side and therefore do not show as differences.

Thanks

Hello Dan,

We were able to reproduce your issue, it seems to be a bug. Bigint identity is not being reverse engineered correctly, which results in the problem you describe.

An issue TDM-1293 has been created. The fix will be probably implemented in the next Beta version of TDM.

Thank you for the information!

Regards,

Lukas

That’s great, thanks Lukas!

Cheers

Dan

From: Lukas Knapek [mailto:bounce-LukasKnapek@toadworld.com]
Sent: 10 April 2015 07:15
To: tdm@toadworld.com
Subject: RE: [Toad Data Modeler - Discussion Forum] Issue with bigint identity in generate change script differencing

RE: Issue with bigint identity in generate change script differencing

Reply by Lukas Knapek

Hello Dan,

We were able to reproduce your issue, it seems to be a bug. Bigint identity is not being reverse engineered correctly, which results in the problem you describe.

An issue TDM-1293 has been created. We will try to fix this bug as soon as possible.

Thank you for the information!

Regards,

Lukas

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Modeler - General notifications altogether.
Toad Data Modeler - Discussion Forum

Flag this post as spam/abuse.

Hi Lukas,

I don’t think this fix made it into v5.4 as I am still seeing the problem - do you know if it will be in the next release? If so, do you have an estimate for when that may be? (I have quite a few bigint fields now and they are making the change script function a bit difficult to work with now)

Cheers

Dan

Hello Dan,

The fix is not in 5.4, but it is in the latest Beta, please give it a try and tell us whether it works for you now.

Regards,

Lukas

Hi Lukas,

Thanks for the quick response! I will give the beta a try and let you know.

Cheers

Dan

From: Lukas Knapek [mailto:bounce-LukasKnapek@toadworld.com]
Sent: 10 August 2015 12:01
To: tdm@toadworld.com
Subject: RE: [Toad Data Modeler - Discussion Forum] Issue with bigint identity in generate change script differencing

RE: Issue with bigint identity in generate change script differencing

Reply by Lukas Knapek

Hello Dan,

The fix is not in 5.4, but it is in the latest Beta, please give it a try and tell us whether it works for you now.

Regards,

Lukas

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Modeler - General notifications altogether.
Toad Data Modeler - Discussion Forum

Flag this post as spam/abuse.

Hi Lukas,

Apologies for the delay in this, I have finally got around to testing the beta and it works great!

The beta does give a big warning about save file incompatibility with previous versions so I have uninstalled it and am back on v5.4. Do you have a rough timeframe for when this beta will go live?

Cheers

Dan

Hi, does anybody have an estimate for the next release that will include this fix?

Cheers

Dan

Hi Dan,

According to my information, the latest TDM 5.5 full release should already contain the fix. Please try it out, if you run into trouble, let us know!

Regards,

Lukas

Hi Lukas,

I just tried v5.5 and it worked great! I didn’t even realise it was out yet – doesn’t TDM usually notify the user of new releases? It has done previously I think, but I couldn’t find any relevant settings in options.

Cheers

Dan

From: Lukas Knapek [mailto:bounce-LukasKnapek@toadworld.com]
Sent: None
To: tdm@toadworld.com
Subject: RE: [Toad Data Modeler - Discussion Forum] Issue with bigint identity in generate change script differencing

RE: Issue with bigint identity in generate change script differencing

Reply by Lukas Knapek

Hi Dan,

According to my information, the latest TDM 5.5 release should already contain the fix. Please try it out, if you run into trouble, let us know!

Regards,

Lukas

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Modeler - General notifications altogether.
Toad Data Modeler - Discussion Forum

Flag this post as spam/abuse.

Hi again Dan,

The notification system is currently undergoing some changes, it will be probably enabled again in the future versions.

As a rule of thumb, new versions are released each spring and august, so feel free to check ToadWorld once or twice a year to stay informed!

Regards,

Lukas