Comments
Sort by recent activity
Hi @ScottSS ,
Thanks for the clarification. I was able to reproduce the behavior in a 2019 instance so I'm going to escalate this to our development team for review. Unfortunately, I don't have a workaround for this just yet but I'll get back to you with further instruction. So sorry for any inconvenience.
/ comments
Hi @ScottSS ,
Thanks for the clarification. I was able to reproduce the behavior in a 2019 instance so I'm going to escalate this to our development team for review. Unfortunately, I don't have a ...
Hi @JohnnyS
As mentioned in the Support Ticket we have open for you, the comparison command line switches are not supported in SQL Change Automation. So sorry. It would be best to use the sqldatacompare.exe in your pipeline in this case. Also, for the record, a SQL Toolbelt license is required if using SQL Compare or SQL Data Compare part of an automated process. Also, each user that is adding changes to this process should have a license of the SQL Toolbelt.
To include the command line .exe In your Bamboo/Octopus Deploy
pipeline, you would just need to add a command line or PowerShell task
that calls on the sqldatacompare.exe that's installed with SQL Change
Automation PowerShell and do the comparison/sync using whatever switches
you need.
The .exe is installed by default in
"C:\Program Files (x86)\Red Gate\SQL Change Automation PowerShell\ in
\SC for SQL Compare and \SDC for SQL Data Compare.
https://documentation.red-gate.com/sc/using-the-command-line
https://documentation.red-gate.com/sdc/using-the-command-line
I hope this helps. Please let me know if you have any further questions.
Kind regards,
Pete Ruiz / comments
Hi @JohnnyS
As mentioned in the Support Ticket we have open for you, the comparison command line switches are not supported in SQL Change Automation. So sorry. It would be best to use the sqldatac...
@josh_stcu ,
Great news! Thanks for the update and I'm glad it is no working as expected.
I'll close the support ticket we have open for you. Please do reach back out if anything else comes up.
Kind regards,
Pete Ruiz
/ comments
@josh_stcu ,
Great news! Thanks for the update and I'm glad it is no working as expected.
I'll close the support ticket we have open for you. Please do reach back out if anything else comes up.
K...
Hello @josh_stcu ,Thanks for your query about SQL
Change Automation. You should be able to completely prevent objects from
other schemas from being deployed by adding a filter to the project.
Please see the documentation below on how to use filters in SQL Change
Automation.
https://documentation.red-gate.com/sca/developing-databases/concepts/filtering
I hope this helps. Please let me know how you get on or if you have any further questions.
Kind regards,
Pete Ruiz
/ comments
Hello @josh_stcu ,Thanks for your query about SQL
Change Automation. You should be able to completely prevent objects from
other schemas from being deployed by adding a filter to the project.
Pl...
Hello @josh_stcu
What comparison options do you have
defined in the release if not using the default? The option to include
dependencies is enabled by default, if you disable it, do you still get
the same issue?
You can disable the option in the
release by adding -IncludeDependencies (it's important to include the
hyphen (-) which disables the option specified.
Here's the documentation which outlines how to use SQL Compare options with SQL Change Automation add-ons:
https://documentation.red-gate.com/sca/deploying-database-changes/automated-deployment-with-sql-source-control-projects/using-sql-compare-options-with-add-ons
Kind regards,
Pete Ruiz / comments
Hello @josh_stcu
What comparison options do you have
defined in the release if not using the default? The option to include
dependencies is enabled by default, if you disable it, do you still g...
Hello @VKh , Thanks for reaching out and sorry that
you're having trouble with SQL Change Automation. We haven't come across
this error before with SQL Change Automation but from the error it
appears that the library called adalsql.dll is either missing or
corrupted. Can you check if this ,dll exists in both C:\Windows\SysWOW64 and C:\Windows\System32 ? If they don't exist, can you try installing the library from the link in the error? http://go.microsoft.com/fwlink/?LinkID=513072 If they do exists, you might be able to resolve the issue following the troubleshooting steps outlined in the two posts below. https://stackoverflow.com/questions/45578395/unable-to-load-adalsql-dll-error-when-calling-invoke-sqlcmd https://winterdom.com/2017/09/27/unable-to-locate-registry-entry-for-adalsql I hope this helps. Please let me know how you get on or if you have any further questions. Kind regards, Pete Ruiz / comments
Hello @VKh ,Thanks for reaching out and sorry that
you're having trouble with SQL Change Automation. We haven't come across
this error before with SQL Change Automation but from the error it
app...
Hello @Gunn0r ,
Thanks for clarifying the scenario. I just tested this to be sure and
I can confirm that this is not possible, unfortunately. You can resolve
the external references for the objects making the references but
cannot add a table and see what external objects are referencing it.
You can add this to our UserVoice forum as a feature request which is monitored by our Product Managers at the link below.
https://sqldependencytracker.uservoice.com/forums/164804-general
Please let me know if you have any further questions.
Kind regards,
Pete Ruiz / comments
Hello @Gunn0r ,
Thanks for clarifying the scenario. I just tested this to be sure and
I can confirm that this is not possible, unfortunately. You can resolve
the external references for the objec...
Hello @Gunn0r , Support for cross-database dependencies was added back in version 2. (release notes). Were you having trouble with this feature? Are there any questions regarding this? Kind regards, Pete Ruiz / comments
Hello @Gunn0r ,Support for cross-database dependencies was added back in version 2. (release notes). Were you having trouble with this feature? Are there any questions regarding this? Kind regards,...
Hello @Infocorp
I believe we have a Support ticket open with you, just copying my reply here: Do you know if the database being cloned has any replication
publications? We've seen this issue before when a database referenced
objects that pertain replication information and don't exist in the
clone because DBCC CLONE doesn't generate the system tables related to
replication, such us sysarticles or sysschemaarticles. I hope this is helpful. Please let me know if you have questions. Kind regards, Pete Ruiz / comments
Hello @Infocorp
I believe we have a Support ticket open with you, just copying my reply here:Do you know if the database being cloned has any replication
publications? We've seen this issue befor...
Hello @ManuelSanrepot , Thanks for your query regarding
SQL Change Automation. You should be able to get around this issue by
adding a filter to prevent the users from being affected in your target.
Please see the documentation below for working with filters in SQL Change Automation: https://documentation.red-gate.com/sca/developing-databases/concepts/filtering Kind regards, Pete Ruiz / comments
Hello @ManuelSanrepot , Thanks for your query regarding
SQL Change Automation. You should be able to get around this issue by
adding a filter to prevent the users from being affected in your targ...