How to commit deleted objects
I have a development database that was identical to my master branch in Git. Then I made a local branch in Git and went into SSMS and created 2 new functions and dropped 1 function. I linked my development database and went to the commit tab, but it only showed the 2 functions I created, so I committed them.
Now when I go into Git I can see the 2 functions I created and I can also see that the one I dropped is still there. I have unlinked and relinked, but I can't get the dropped function to show up on the commit tab.
I fired up SQL Compare and sure enough if I compare the live database schema with what I have committed to the branch it shows that the dropped function is not present in the live database but is present in the local branch.
However, I can't figure out how to sync changes from a live database into source control using SQL Compare. It just wants to make a tsql script, which isn't very relevant for making changes to source control.
I only have a week left on my evaluation and I thought I had figured everything out, but this one stumps me.
thx v much for your help,
0 · Share on Twitter