Joined: 15 Jun 2013
|Posted: Sat Jun 15, 2013 1:09 am Post subject: Same problem, pending changes are disappearing
Here is the brief summary of my settings.
OS: windows 2008R2
SQL: Microsoft SQL 2008
SQL Source Control Installed: 220.127.116.11
SVN: TortoiseSVN 1.7.10
I have a batch file to deploy two different databases and both databases are linked in the shared database development mode. Here is what I have been experienced.
1. First run, there wasn't way detection after the deployment. No blue dots showing on object explorer. Only two green icons are showing for the linked databases and these databases are linked to SVN repository.
2. I tab back and forward between "Setup" and "Commit changes" under SQL Source Control. Then it finds out the pending changes on the first databases as blue dots in tables and stored procedures. Even tough my SQL batch contains the changes of the schema and data for both databases, it picked up and showed blue dots only in the first database. I was able to make the first check in into the first database. but there is no sign or blue dots on the second databases at all.
3. I reboot the server and tried to deploy from the batch file. Now, both databases are showing changes in blue dots. So, I clicked "Commit Changes" tab. Then, all the blue dots are disappeared all of suddent. Never coming back. even though I restarted SSMS or refresh.
Then, I did the same attempt to the 2nd databases to check in and those blue dots are gone again after tab to "Commit Changes".