Comments
Sort by recent activity
I keep running into this problem where I need to rerun scripts that failed on certain databases. Finding the few databases needed to rerun in a list of 100+ in the distribution list is getting very tedious. It would be nice to have a button that checks off just the databases the script failed on in the distribution list. Any update on this? / comments
I keep running into this problem where I need to rerun scripts that failed on certain databases. Finding the few databases needed to rerun in a list of 100+ in the distribution list is getting ver...
Yes exactly. In the dev/stage environment the sproc would be clear, but on live it will be encrypted. In version 4 it would mark it as different (regardless if it actually changed) and allow you to script the update. In version 5, you can't do it.
Thanks. / comments
Yes exactly. In the dev/stage environment the sproc would be clear, but on live it will be encrypted. In version 4 it would mark it as different (regardless if it actually changed) and allow you ...
In version 4, if it couldn't decrypt the sproc, it would mark it as being different and allow you to include the update in the script. This was good.
In version five you no longer have that option. This is bad.
Try it out.
It doesn't seem like a big difference, but when you have thousands of sprocs, some encrypted, its a huge deal.
Thanks. / comments
In version 4, if it couldn't decrypt the sproc, it would mark it as being different and allow you to include the update in the script. This was good.
In version five you no longer have that option...
No, I never found a solution. We ended up taking off replication on the databases we compare and rolling back all of the "not for replication" changes it made, so it became a non-issue. / comments
No, I never found a solution. We ended up taking off replication on the databases we compare and rolling back all of the "not for replication" changes it made, so it became a non-issue.
Removed / comments
Removed
Yes you are correct. In 5.3, they now compare as identical in the top panel if that is the only difference, but the lines show as different in the lower details panel. Good enough for me... / comments
Yes you are correct. In 5.3, they now compare as identical in the top panel if that is the only difference, but the lines show as different in the lower details panel. Good enough for me...
I just upgraded to 5.3, and can confirm this is still an issue. I checked connect.microsoft.com for the bug and Microsoft states they are not planning to fix this issue of adding the extra parenthesis on check constraints. So it would be nice to have SQL Compare ignore these differences. / comments
I just upgraded to 5.3, and can confirm this is still an issue. I checked connect.microsoft.com for the bug and Microsoft states they are not planning to fix this issue of adding the extra parenth...
Yes, I have the latest version installed. I tried renaming the SQL Prompt applicatin folder and ignoring the warning, but I lost intellisense too. Finally had to uninstall. Oh well, I will probably reinstall after this project.
One big problem I had was when I was highlighting some code and holding down the shift-arrow key using the repeat key, it got impossibly slow. / comments
Yes, I have the latest version installed. I tried renaming the SQL Prompt applicatin folder and ignoring the warning, but I lost intellisense too. Finally had to uninstall. Oh well, I will prob...
We have about 180 databases across 6 servers now, and they are constantly changing with new databases and servers being added! The utility mentioned is not nearly enough to keep up with this.
I ended up writing a .NET application that builds the distribution list XML file that Multi Script uses each time it runs. Gives me exact control over building the lists I need in different ways. Also allows me to order the database list based on server so it will execute all scripts on all servers at once (since Multi Script seriosly lacks the option for parallel execution across servers instead of databases)
I posted the code to generate the list at: http://spivey24.blogspot.com/2011/11/sq ... dgate.html / comments
We have about 180 databases across 6 servers now, and they are constantly changing with new databases and servers being added! The utility mentioned is not nearly enough to keep up with this.
I en...
Depending on OS, the filepath should be something like: C:\Users\XXXX\AppData\Roaming\Red Gate\SQL Multi Script\Application.dat
I posted the code to generate the list at: http://spivey24.blogspot.com/2011/11/sq ... dgate.html / comments
Depending on OS, the filepath should be something like: C:\Users\XXXX\AppData\Roaming\Red Gate\SQL Multi Script\Application.dat
I posted the code to generate the list at:http://spivey24.blogspot.co...