Comments
Sort by recent activity
Hello @ptrubs, The default behavior is that the the Pre-Deployment script is executed before the section of the script
that contains the schema changes generated by SQL Compare, and the
Post-Deployment script is executed after. This means that it would probably make more sense to include any INSERT statements in a Post-Deployment script rather than a Pre-Deployment script.
I hope this helps. Cheers,
Pete Ruiz Redgate Product Support
/ comments
Hello @ptrubs,The default behavior is that the the Pre-Deployment script is executed before the section of the script
that contains the schema changes generated by SQL Compare, and the
Post-Deplo...
@ptrubs Thanks for your query about SQL
Source Control. By default the temporary database should be created
first, then the pre-deployment scripts would be deployed followed by the
schema objects and lastly the post-deployment script. Are you able to
provide a copy of what you included in the pre-deployment script? Also,
do you have a copy of the log files for this build?
Kind regards,
Pete Ruiz
/ comments
@ptrubsThanks for your query about SQL
Source Control. By default the temporary database should be created
first, then the pre-deployment scripts would be deployed followed by the
schema objects...
Hello @Dacius12
Sorry you're having trouble with SQL Source Control. Can you please try unlinking the database from source control, delete the content in the caches folder located in %localappdata%\Red Gate\SQL Source Control 7\Caches, then relink the database to source control and confirm if anything changes?
Also, what happens if you first do a pull from the Get Latest tab then try to do a commit?
Kind regards,
Pete Ruiz
/ comments
Hello @Dacius12
Sorry you're having trouble with SQL Source Control. Can you please try unlinking the database from source control, delete the content in the caches folder located in %localappdata...
Hello @Dave Pendleton
Thanks for reaching out and sorry that you're having trouble with SQL Prompt. Do you mind sharing a bit more about the paint feature that you're utilizing when this happens? Would it be possible to uninstall SQL Prompt, then reinstall it from the Visual Studio Market Place and confirm if anything changes?
Kind regards,
Pete Ruiz
/ comments
Hello @Dave Pendleton
Thanks for reaching out and sorry that you're having trouble with SQL Prompt. Do you mind sharing a bit more about the paint feature that you're utilizing when this happens? ...
Hello @JBrazell
Thanks for your query about SQL Doc. You have the ability to save a project which includes the settings for a specific database, however, there isn't an option just to save off or export the specific settings to be reused.
https://documentation.red-gate.com/sdoc/working-with-projects I hope this helps. Please let me know if you have further questions.
Cheers,
Pete Ruiz
/ comments
Hello @JBrazell
Thanks for your query about SQL Doc. You have the ability to save a project which includes the settings for a specific database, however, there isn't an option just to save off or ...
Hello @Jim_In_Florida , Thanks for reaching out and sorry
that you're having trouble with SQL Compare. A support ticket has been
opened for you and I'll be emailing you shortly. Kind regards, Pete Ruiz / comments
Hello @Jim_In_Florida , Thanks for reaching out and sorry
that you're having trouble with SQL Compare. A support ticket has been
opened for you and I'll be emailing you shortly. Kind regards, Pet...
Hello @BenKim , Thanks for reaching out and sorry
that you're displeased with SQL Data Compare. We do have the below help
article which outlines troubleshooting steps for improving the
performance of SQL Data Compare. https://documentation.red-gate.com/sdc/troubleshooting/common-issues/troubleshooting-comparison-and-deployment-performance-problems Regarding
the first issue mentioned where there's no constraint after setting a
unique key, do you mind sharing a bit of an example to help replicate it
on our end? Kind regards, Pete Ruiz Redgate Product Support / comments
Hello @BenKim , Thanks for reaching out and sorry
that you're displeased with SQL Data Compare. We do have the below help
article which outlines troubleshooting steps for improving the
performan...
Hello @BenDAltus ,
We've created a support ticket for you and I've sent you an email. Can you please reply there?
Kind regards,
Pete Ruiz
/ comments
Hello @BenDAltus ,
We've created a support ticket for you and I've sent you an email. Can you please reply there?
Kind regards,
Pete Ruiz
Hi @Todd_G
I just tested this and it seems to be working properly in 10.6.5 for me. We've released 10.6.6 today, can you install this version from the link below and confirm if you still experience the same issue?
Download SQL Prompt 10.6.6.18829:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.6.6.18829.exe Kind regards,
Pete Ruiz
Redgate Product Support
/ comments
Hi @Todd_G
I just tested this and it seems to be working properly in 10.6.5 for me. We've released 10.6.6 today, can you install this version from the link below and confirm if you still experienc...
Hello @NewGuy
We've released SQL Prompt 10.6.7 which includes a fix for the issue you reported.
You can download the latest installer from the link below: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.6.7.19129.exe Please let me know if you have any questions.
Kind regards,
Pete Ruiz
/ comments
Hello @NewGuy
We've released SQL Prompt 10.6.7 which includes a fix for the issue you reported.
You can download the latest installer from the link below:https://download.red-gate.com/checkforupd...