I am getting a Primary key violation during the build process in Team city.
I use Reg gate source control to link one of the static data tables.
Both my local instance and the target database have the same data and same number of rows in the table.
When i commit the change and then push it it triggers the build in Teamcity.
But the build process stops with an error stating 'cannot insert duplicate values to the table'.Why it should show such an error?.I am just trying to link the table on my local instance DB to the source control.
Any thoughts on this are much appreciated.