Activity overview
Latest activity by spivey24
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...
Parallel execution against servers not databases
It would be very useful if there was another option for parallel execution:
Databases per Server to execute against simultaneously.
For example, we have about 180 databases across 6 database server...
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...
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...
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...
Temporarily disable SQL Prompt
Is there a way to set up a toolbar or menu item to temporarily disable SQL Prompt - similar to how I can turn Intellisense on and off.
I am working with a large script and SQL Prompt is slowing my ...
SVN post-commit hook to update QA database
Is there a way to do an SVN post-commit hook so we can update the QA databases when a developer checks in the code? According to a couple of articles I found on this site, I would need to set up s...
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.
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...
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 ...