Comments
Sort by recent activity
Hi @BrienM
Thanks for your query regarding
SQL Compare. Unfortunately, there isn't any history of changes stored in
SQL Compare, however, would it help to generate a comparison report
that you can reference to see what the differences were?
Please see the documentation below which outlines how to generate reports.
https://documentation.red-gate.com/sc/reviewing-the-comparison-results/generating-a-report
Kind regards,
Pete Ruiz / comments
Hi @BrienM
Thanks for your query regarding
SQL Compare. Unfortunately, there isn't any history of changes stored in
SQL Compare, however, would it help to generate a comparison report
that you...
@echovault
I raised your concern again with our
team of developers and they've advised that they will revisit and review
this over the next coming weeks. There are no guarantees that anything
will be changed but I will keep you posted on what decisions are made
going forward. I'll put our support ticket on hold for now and will get
back to you with any future updates. Again, so sorry for any
inconvenience this has caused.
Please do let me know if you have any questions.
Kind regards,
Pete Ruiz
Redgate Product Support
/ comments
@echovault
I raised your concern again with our
team of developers and they've advised that they will revisit and review
this over the next coming weeks. There are no guarantees that anything
...
Hello sam_alexander , This is actually an issue with Transaction Handling and you can work around this
by changing the Transaction Isolation Level or using the NoTransactions
error option, please see the following Help Center article:
https://productsupport.red-gate.com/hc/en-us/articles/360007807893-The-operation-could-not-be-performed-because-OLE-DB-provider-for-linked-server-was-unable-to-begin-a-distributed-transaction
I hope this helps. Please let me know if you have any questions.
Kind regards,
Pete Ruiz
Redgate Product Support
/ comments
Hello sam_alexander ,This is actually an issue with Transaction Handling and you can work around this
by changing the Transaction Isolation Level or using the NoTransactions
error option, please ...
Hello @BryanH ,
What version of SQL Server Management Studio do you have installed on this machine? Also, what .NET Framework is installed? From the error message, it looks like you don't have SSMS installed yet which is required before you can install the add-on. Can you confirm this?
Kind regards,
Pete Ruiz
/ comments
Hello @BryanH ,
What version of SQL Server Management Studio do you have installed on this machine? Also, what .NET Framework is installed? From the error message, it looks like you don't have SSM...
Hi @BryanH ,
Sorry, you actually mentioned the SSMS version. We've opened a support ticket for you. Can you please reply with the installation log files? You can retrieve the log file by clicking on the Redgate icon at the top left of the installation wizard.
[image] Kind regards,
Pete Ruiz
/ comments
Hi @BryanH ,
Sorry, you actually mentioned the SSMS version. We've opened a support ticket for you. Can you please reply with the installation log files? You can retrieve the log file by clicking ...
Hello @BogdanS , Thanks for your query regarding SQL
Change Automation. There are a few ways to include data in your pipeline
using SQL Change Automation. If you're using SQL Source Control as your
development source, then you have the option to link static data to
version control. Please see the documentation below for more details on
this. https://documentation.red-gate.com/soc6/common-tasks/link-static-data You can also use SQL Change Automation PowerShell to deploy static data as well and the documentation below outlines this. https://documentation.red-gate.com/sca/deploying-database-changes/automated-deployment-with-sql-source-control-projects/deploying-static-data-with-sql-change-automation-powershell Lastly,
you can also use the SQL Data Compare command line to compare and
deploy data. In AzureDevops you can setup an additional release step
that calls on the SQL Data Compare command line. Please see the
documentation below for more information on the SQL Data Compare command
line. https://documentation.red-gate.com/sdc/using-the-command-line I hope this is helpful. Please let me know if you have any further questions. Kind regards, Pete Ruiz / comments
Hello @BogdanS , Thanks for your query regarding SQL
Change Automation. There are a few ways to include data in your pipeline
using SQL Change Automation. If you're using SQL Source Control as yo...
Hello @BogdanS , Thanks for the update. You are
correct, you would need to create a separate PowerShell step and point
it to the install path where the SQLDataCompare.exe is located. I'm glad
you were able to get this working. Please let me know if you have any further questions. Kind regards, Pete Ruiz / comments
Hello @BogdanS , Thanks for the update. You are
correct, you would need to create a separate PowerShell step and point
it to the install path where the SQLDataCompare.exe is located. I'm glad
yo...
Hello @sasankj , Thanks for your query regarding SQL Change
Automation. The permissions required varies case to case and depends on
the objects in the database and what you're trying to deploy. You can reference the documentation below which gives some recommendations: https://documentation.red-gate.com/sc/getting-started/requirements/permissions-required-to-use-sql-compare I hope this is helpful. Please let me know if you have any further questions. Kind regards, Pete Ruiz Product Support Engineer / comments
Hello @sasankj ,Thanks for your query regarding SQL Change
Automation. The permissions required varies case to case and depends on
the objects in the database and what you're trying to deploy. Yo...
Hello @DonFerguson , I've discussed this with the team
and it appears that, with the option enabled, a server will always be
red if it's got an error and the error will be visible on the dashboard.
With the option disabled, the server will disappear from the dashboard
if the error causes Monitor to no longer be able to sample it.
Unfortunately, we don't have a full list of all the errors or
circumstances that would cause the server to drop off from the
dashboard. I hope this helps. Please let me know if you have any questions. Kind regards, Pete Ruiz / comments
Hello @DonFerguson , I've discussed this with the team
and it appears that, with the option enabled, a server will always be
red if it's got an error and the error will be visible on the dashboar...
@DonFerguson Thanks for reaching out. In Configuration>Display settings, you have the option to Force errored instances to display red on global overview.
[image]
I hope this helps. Please let me know if there are any questions.
Kind regards,
Pete Ruiz
Product Support Engineer
/ comments
@DonFerguson Thanks for reaching out. In Configuration>Display settings, you have the option to Force errored instances to display red on global overview.
I hope this helps. Please let me know...