Red Gate forums :: View topic - Ignore identity seed doesn't work with other changes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Ignore identity seed doesn't work with other changes

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dsp



Joined: 30 Jan 2010
Posts: 17

PostPosted: Thu Mar 14, 2013 10:40 pm    Post subject: Ignore identity seed doesn't work with other changes Reply with quote

I found out that renaming a column with an identity seed caused the identity to change.

db1: orgName int identity(500,1)
db2: orgName int identity(3000,1)

rename at db1: newName int identity(500,1)
After sql compare the column at db2 should be newName int Identity(3000,1), but it turned 500,1.

Danny Springer
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Mon Mar 18, 2013 11:28 am    Post subject: Reply with quote

Many thanks for your post and apologies for inconvenience caused.

We have logged a support call and would like to investigate this issue further.

I will email you with few more questions.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Tue Mar 19, 2013 11:06 am    Post subject: Reply with quote

As per our live chat it is SQL Compare's feature that allows to ignore the identity seed and increment value during comparison but SQL Compare will not ignore the settings during deployment.

Hope this answers your question.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
thejamie



Joined: 28 Oct 2011
Posts: 3

PostPosted: Tue Jan 28, 2014 4:52 pm    Post subject: Reply with quote

It looks like the seed value depends on the presence of a primary key or not. If for some reason, the Identity key is not a primary key, the process that sets the DBCC CheckIdent (tablename,RESEED,0) does not get processed properly when you are not running the wizard in the table by table section but attempt to run it from the first tab ("Data Sources"). Try running from the tab that says "Tables and Views" and mark the column as an identity column. Otherwise, when not a primary key, the program does not seem to recognize that there is an identity column in the field. Or perhaps the Ignore Identity property is the default but it is over-ridden in the Tables and Views tab section. I can't quite figure out which but I do know that if I run from the Tables and Views, it seems to reset the identity if I check the box on the table that has an identity set. Seems to me to be counter-intuitive. I would think that if the table has an identity set, it should automatically reset that value.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group