| Author |
Message |
dsp
Joined: 30 Jan 2010
Posts: 17
|
 Posted: Thu Mar 14, 2013 10:40 pm Post subject: Ignore identity seed doesn't work with other changes |
 |
|
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 |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 595
Location: Cambridge
|
| Posted: Mon Mar 18, 2013 11:28 am Post subject: |
|
|
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 |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 595
Location: Cambridge
|
| Posted: Tue Mar 19, 2013 11:06 am Post subject: |
|
|
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 |
|
|
|
|
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
