Red Gate forums :: View topic - SQL Data Compare attempting to set IDENTITY columns to NULL
Return to www.red-gate.com RSS Feed Available

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

SQL Data Compare attempting to set IDENTITY columns to NULL

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



Joined: 06 Sep 2013
Posts: 2

PostPosted: Fri Sep 06, 2013 3:36 pm    Post subject: SQL Data Compare attempting to set IDENTITY columns to NULL Reply with quote

I am using SQL Data Compare 10.2.3.5. We use the tool regularly to save changes to data made by individual developers, and then apply those changes to other environments. Our databases are SQL Server 2005/2008.

Now I'm trying to generate a database from scratch from source control, instead of applying incremental changes. The target database is empty, and there are about 24000 differences to be applied. When I deploy, I get the error "DEFAULT or NULL are not allowed as explicit identity values".

Looking at the deployment script, I can see that SQL Data Compare is trying to set the value of identity columns in several (but not all) tables to NULL. In the .sql data files in source control, the INSERT statements do not store any value for the identity columns (as I think it should be). Yet these NULLs are generated at deployment time. I've tried using the re-seed identity columns option, but this makes no difference.

I would appreciate anyone who could point me in the right direction on this. Right now, I'm looking at having to edit a very large number of changes in the deployment script to get this database created.

Thanks,

Kevin
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Tue Sep 17, 2013 6:19 pm    Post subject: Reply with quote

Hi Kevin - is there any reason you're still using SQL Data Compare 10.2? We've released a few updates to the tool since then - the most recent version is 10.4.8.62.

If you could update to that version and let me know if you're still seeing this issue that'd be great - you can update from within the tool by going to Help->Check for Updates.
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
kevin_bkt



Joined: 06 Sep 2013
Posts: 2

PostPosted: Tue Sep 17, 2013 6:27 pm    Post subject: Reply with quote

11 days is a bit long for a response, don't you think? I've long since had to come up with another way to perform the task I was attempting.

Next chance I have, I will try what you suggest, but don't know when that will be.
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Tue Sep 17, 2013 6:34 pm    Post subject: Reply with quote

Yes, sorry - I'm afraid this got lost in our system. Usually we attempt to respond within 8 business hours for supported customers - I'm really sorry it took us so long to get back to you this time. If you do want to come back to this at a later date do let us know and I'll do my best to help out.
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
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