SQL Source Control static data change behaves strange
Guenter
Posts: 12 Bronze 1
I am using SQL Source Control to track one schema inside a DEV database. I am tracking tables, views, SPs and static data in some tables. I am the only developer on that database and SQL Source Control project.
Every Time I change the data in one of the static data tables, SQL Data Compare tells me there's a conflict in the data. The comparison pane shows me the "theirs" part as "disconnected" and the "mine" part with some (but not all) lines of data that changed, but the script only contains one of the (usually 5 to 7) columns, so the script shown in the "mine" page would be unusable as a data population script.
However, when I select 'keep mine', the tool saves the correct script (which differs substantially from the display in the 'mine' pane).
Here is a sample output from the merge pane where I simply added one record to the table which contained 25 entries on the last commit:
Every Time I change the data in one of the static data tables, SQL Data Compare tells me there's a conflict in the data. The comparison pane shows me the "theirs" part as "disconnected" and the "mine" part with some (but not all) lines of data that changed, but the script only contains one of the (usually 5 to 7) columns, so the script shown in the "mine" page would be unusable as a data population script.
However, when I select 'keep mine', the tool saves the correct script (which differs substantially from the display in the 'mine' pane).
Here is a sample output from the merge pane where I simply added one record to the table which contained 25 entries on the last commit:
Tagged:
Answers
I'm sorry to hear you're experiencing this issue and it seems very odd to me!
In order to troubleshoot this I'll need some extra information from you, what I'll do is reach out via a support ticket and we can investigate this.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?