Comments
Sort by recent activity
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...
I have a search stored procedure that scans all of syscomments for text like some param. It takes 4 seconds on a slow server with 1400 stored procedures. It would be nice if SQL Search degraded to a brute force scan if no index existed yet.
If I have a quick search I always use the search sproc instead because I will get results faster, but I really like being able to click on the object and have it highlight in the Object Explorer with SQL Search. / comments
I have a search stored procedure that scans all of syscomments for text like some param. It takes 4 seconds on a slow server with 1400 stored procedures. It would be nice if SQL Search degraded t...
Its a bug when you are editing existing code. I would love to turn this off. / comments
Its a bug when you are editing existing code. I would love to turn this off.