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:
Hi Guenter
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: