Red Gate forums :: View topic - Primary key has moved on
Return to www.red-gate.com RSS Feed Available

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

Primary key has moved on

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
joshdanhall



Joined: 06 Jan 2012
Posts: 1

PostPosted: Fri Jan 06, 2012 5:06 am    Post subject: Primary key has moved on Reply with quote

Hi,

I'm using Data Compare to create scripts to populate reference data into multiple environments. With the scripts generated I now run into problems because the primary key from one INSERT may no longer be appropriate for the target environment. For example that environment may already have generated a row with that id value, so my script will fail.

Does the Data Compare tool offer a solution for this, or will I have to hand-edit the scripts to handle the dynamic nature of my requirements?

Note: The primary key value is also used in subsequent INSERTs, as it is a foreign key for other table.

Thanks in advance.

Regards, Josh
Back to top
View user's profile Send private message
andy.campbell.smith



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

PostPosted: Mon Jan 09, 2012 11:47 am    Post subject: Reply with quote

I'm afraid SQL Data Compare doesn't have multiple-environment support, so there's not really any built-in functionality designed to handle situations like this. Do let us know if you come up with a nice solution, but there's not much I can really offer you, sorry!
_________________
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