Comments
Sort by recent activity
Did you still need some help with this? I sent you a message through the support ticket we opened, but I didn't hear anything back. / comments
Did you still need some help with this? I sent you a message through the support ticket we opened, but I didn't hear anything back.
sp_msforeachtable is an undocumented feature, so we would probably take the stance that we don't support it.
However, it seems to work ok for me. What's the 'hic-up' you have with SQL Prompt? / comments
sp_msforeachtable is an undocumented feature, so we would probably take the stance that we don't support it.
However, it seems to work ok for me. What's the 'hic-up' you have with SQL Prompt?
Sorry you're hitting this. It's a known issue and we should be releasing a fix for it in the next update. Our internal tracking code for this is SDC-1388.
I'm not sure exactly when the update will go out, but it should be in the next few weeks. I can send you a link to a previous version if you can't wait for the fix. / comments
Sorry you're hitting this. It's a known issue and we should be releasing a fix for it in the next update. Our internal tracking code for this is SDC-1388.
I'm not sure exactly when the update will ...
Thanks for your post.
This might be something we've fixed in a more recent version.
Could you try SQL Data Compare 10, or at least the most recent version of SQL Data Compare 9 (9.1.0.464)
Let me know how you get on. / comments
Thanks for your post.
This might be something we've fixed in a more recent version.
Could you try SQL Data Compare 10, or at least the most recent version of SQL Data Compare 9 (9.1.0.464)
Let me k...
Can you uninstall 10.2.0.916 and install the following version instead? ftp://support.red-gate.com/patches/SQL_ ... .0.777.zip
It's basically the same, just CFU works. / comments
Can you uninstall 10.2.0.916 and install the following version instead?ftp://support.red-gate.com/patches/SQL_ ... .0.777.zip
It's basically the same, just CFU works.
Yes, check for updates does appear to be broken in 10.2.0.916. We have the bug logged under the code SC-5825.
You'll probably never know when we release the fix because you can't check for updates, so I'll try to keep this case open so I can send you a link manually.
Thanks for reporting this. / comments
Yes, check for updates does appear to be broken in 10.2.0.916. We have the bug logged under the code SC-5825.
You'll probably never know when we release the fix because you can't check for updates,...
Thanks for your post.
I'm afraid neither are possible with the current version.
The option to create a scripts folder is designed to be used to represent the complete schema of the database so it can be used as a data source. The scripts themselves aren't really designed to be deployed to other environments.
Likewise, the deployments scripts that can include 'IF EXISTS' are designed to be a single script and can't be broken down per object, unless you go through and create a project for each object. If you right-click on an object in the results grid, you can create a single deployment script for that object, but you can't get it do that for all objects in one go.
If you don't mind me asking, why do you need the existence checks for each script?
Feel free to log the suggestion on our uservoice site if you need it added to the tool. / comments
Thanks for your post.
I'm afraid neither are possible with the current version.
The option to create a scripts folder is designed to be used to represent the complete schema of the database so it c...
I think I could sort of reproduce the problem you're having with a 300 ms delay, but with a 1 ms delay I couldn't type fast enough for the join selection to not be noticed.
Try it out when you get the chance; it seemed to help for me. / comments
I think I could sort of reproduce the problem you're having with a 300 ms delay, but with a 1 ms delay I couldn't type fast enough for the join selection to not be noticed.
Try it out when you get ...
Thanks for your post.
By default, there is a 300 millisecond delay before the suggestion is triggered.
Could you try decreasing this delay and see if that helps?
You can set it through SQL Prompt 5 > Options > Behaviour > Triggering Behaviour / comments
Thanks for your post.
By default, there is a 300 millisecond delay before the suggestion is triggered.
Could you try decreasing this delay and see if that helps?
You can set it through SQL Prompt 5...
Thanks for your post.
There isn't much you can do to speed up the comparison, unfortunately.
What you might like to try would be to take a SQL Compare snapshot of the source schema, and then copy it over to the remote site. You can then do the sync' locally on the remote site. This should help if the problem is with communication over the WAN.
I hope it helps. / comments
Thanks for your post.
There isn't much you can do to speed up the comparison, unfortunately.
What you might like to try would be to take a SQL Compare snapshot of the source schema, and then copy i...