Comments
Sort by recent activity
Hello @dlrhosseinm
A support ticket was opened for the customer who reported this issue and was resolved.
The issue was caused by a stored procedure. The customer had to remove the offending object from source control and add re-add it.
Are you experiencing the same issue? If so, you can try the following: 1 - Unlink that database from Source Control 2 - Close SSMS 3 - Delete the contents of all subfolders inside %localappdata%\Red Gate\SQL Source Control 4\Caches (Please note that %localappdata% is a Windows Environment variable that usually corresponds to C:\Users\{username}\AppData\Local ) 4 - Use SQL Compare to synchronize your DB with the repository 5 - Relink DB with the repository
/ comments
Hello @dlrhosseinm
A support ticket was opened for the customer who reported this issue and was resolved.
The issue was caused by a stored procedure. The customer had to remove the offending obje...
@ldelpozo
Hello Luis,
A support ticket has already been opened for this issue by your colleague Pablo Lin. Ticket reference is 271393. It appears that the agent is unable to access the local path. We recommend using a hosted agent and adding the file to the Azure repo.
Please let me know if this helps or if you have any questions.
Pete Ruiz
Product Support Engineer Redgate
/ comments
@ldelpozo
Hello Luis,
A support ticket has already been opened for this issue by your colleague Pablo Lin. Ticket reference is 271393.It appears that the agent is unable to access the local path....
Hello @davesbrown
That's great news. Glad you were able to resolve the issue.
Please reach back out if anything else comes up.
Cheers,
Pete Ruiz Product Support Engineer
/ comments
Hello @davesbrown
That's great news. Glad you were able to resolve the issue.
Please reach back out if anything else comes up.
Cheers,
Pete RuizProduct Support Engineer
Hello @davesbrown
Thanks for reaching out and sorry that you're having trouble with SQL Compare.
I tried a few scenarios on my end to try to try to replicate this but no luck.
Can you please provide CREATE scripts for the function as it appears in the source as well as in the target so we can try and replicate this?
Kind regards,
Pete Ruiz
Product Support Engineer
/ comments
Hello @davesbrown
Thanks for reaching out and sorry that you're having trouble with SQL Compare.
I tried a few scenarios on my end to try to try to replicate this but no luck.
Can you please pro...
@ozhug
Is there any way to test with a local development database? Do you get the same results?
Also, is there anyway we can get a copy of the log files? We can continue communication through a Support ticket if that's better.
Kind regards,
Pete Ruiz
Product Support Engineer.
/ comments
@ozhug
Is there any way to test with a local development database? Do you get the same results?
Also, is there anyway we can get a copy of the log files? We can continue communication through a S...
Hello Karthik, Thanks for reaching out and sorry that you're having trouble with SQL Change Automation. 1. how do I get the provisioning script to run and create the new database if it doesn't exist as part of the deployment? If
using SQL Change Automation projects, default provisioning settings, I
would expect the database should be created. We'll need to see the
project in order to try and troubleshoot why this is happening. 2. how do I get the baseline script to execute on a newly created empty database? The
baseline script should run on a newly created database, if it doesn't
it's probably because it "thinks" the target database is not empty. Can
you verify if the target is an empty database? 3. how to enable post-schema check on deployment? Not
sure if the post-schema check is run on SCA projects as this is
different from Source Control projects. I'll need to check with the team
since there's also no option to enable this in the setting. Can you please provide a copy of your SCA project for review?
Kind regards,
Peter Ruiz
Product Support Engineer
/ comments
Hello Karthik, Thanks for reaching out and sorry that you're having trouble with SQL Change Automation. 1. how do I get the provisioning script to run and create the new database if it doesn't exis...
Hello @ozhug
Are you using a local shadow database? Also, is the development database local also or are you connecting via remote?
Pete Ruiz
Product Support Engineer
/ comments
Hello @ozhug
Are you using a local shadow database? Also, is the development database local also or are you connecting via remote?
Pete Ruiz
Product Support Engineer
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...
Hello @JPS
You can do this by setting the same server/database as the source and target then mapping the schemas and tables to each other.
Please see the documentation below which outlines how to map schemas and tables:
https://documentation.red-gate.com/sc/setting-up-the-comparison/mapping-tables-and-columns https://documentation.red-gate.com/sc/setting-up-the-comparison/mapping-owners I hope this helps. Please let us know if you have any further questions.
Cheers,
Pete Ruiz
Redgate Product Support
/ comments
Hello @JPS
You can do this by setting the same server/database as the source and target then mapping the schemas and tables to each other.
Please see the documentation below which outlines how to...
Hello @ozhug
Thanks for your query about SQL Change Automation. Unfortunately, there isn't a way to change this. By default, the SCA extension in SSMS will start to do a comparison to see what has changed. You don't need to generate the migration script. You should be able to click the other tabs though and move on from the 'generate migrations' tab. Kind regards, Pete Ruiz
Product Support Engineer.
/ comments
Hello @ozhug
Thanks for your query about SQL Change Automation. Unfortunately, there isn't a way to change this. By default, the SCA extension in SSMS will start to do a comparison to see what has...