Activity overview
Latest activity by Pete_Ruiz
@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 @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...
Hello @ptrubs
What sort of objects did you add the pre-deployment script and why did you choose to use a pre-deployment script in this way? Can you please send over a copy of the pre-deployment script for review?
Kind regards,
Pete Ruiz
/ comments
Hello @ptrubs
What sort of objects did you add the pre-deployment script and why did you choose to use a pre-deployment script in this way?Can you please send over a copy of the pre-deployment scr...
Hello @...
Thanks for your query about SQL Source Control. When you delete an object on the database, you would then need to commit it to the local repo, then you would need to push the change from the local repo to the remote in order it to be removed from your Bitbucket repo. You may be able to recover the object using the SQL Source Control revision history by right clicking on the database in Object Explorer and select View history. [image] I hope this helps. Please let me know if you have any further questions.
Kind regards,
Pete Ruiz
/ comments
Hello @...
Thanks for your query about SQL Source Control. When you delete an object on the database, you would then need to commit it to the local repo, then you would need to push the change fro...