Activity overview
Latest activity by Sergio R
Hi, This appears to be related to Static Data, you might be able to get more information by using SQL Data Compare to simulate deploying static data to an empty database. / comments
Hi,This appears to be related to Static Data, you might be able to get more information by using SQL Data Compare to simulate deploying static data to an empty database.
I am afraid that without "include:identical" you will get an error if there are no changes. The suggested workaround would be to add some error handling code to your command instead of using "include:identical" / comments
I am afraid that without "include:identical" you will get an error if there are no changes. The suggested workaround would be to add some error handling code to your command instead of using "inclu...
Hi, It looks like you might have set 4.2.20196 as the version to use on the add-on settings. I would expect the agent to start using the installed version if you change this setting to use the latest version. / comments
Hi,It looks like you might have set 4.2.20196 as the version to use on the add-on settings.I would expect the agent to start using the installed version if you change this setting to use the latest...
Hi Daniel, Flyway supports deploying to all the different database platforms you've mentioned. Currently, our tool is able to generate migration scripts for SQL Server and Oracle and we are about to have this feature for Postgres scripts as well (if you would like to enroll in the Early Access Program for the Postgres script generation feature please register here: https://redgate.research.net/r/FWD-documentation). I hope this answers your question but if not please let me know. / comments
Hi Daniel,Flyway supports deploying to all the different database platforms you've mentioned.Currently, our tool is able to generate migration scripts for SQL Server and Oracle and we are about to ...
Hi Peter, Yes, you can automate the initial installation of SQL Monitor, however the repository database needs to be pre-created. It's possible to do this in a script, for example you can use the Invoke-SqlCmd Powershell cmdlet. Here's a simple example: invoke-sqlcmd -query "CREATE DATABASE [RedgateMonitor]" / comments
Hi Peter,Yes, you can automate the initial installation of SQL Monitor, however the repository database needs to be pre-created. It's possible to do this in a script, for example you can use the In...
I am afraid it is not possible to use the comparisonoptions.xml file in SQL Change Automation Powershell, you'll need to specify non-default options in every task. / comments
I am afraid it is not possible to use the comparisonoptions.xml file in SQL Change Automation Powershell, you'll need to specify non-default options in every task.
You can exclude the code that creates that view from script verification : https://documentation.red-gate.com/sca/developing-databases/concepts/verifying-projects/excluding-objects-from-script-verification Alternatively, you could add some code in that migration that checks for the existence of 'dbo.crm_bkl_asset' and creates it if it doesn't exist so that the dependency relation is satisfied. / comments
You can exclude the code that creates that view from script verification : https://documentation.red-gate.com/sca/developing-databases/concepts/verifying-projects/excluding-objects-from-script-veri...
SQL Monitor does not provide such a list, however, the server will be identified as suspended on the "Overview" and "Monitored Servers" page. You can also schedule a "maintenance window" in which case the server will come out of maintenance automatically when the scheduled maintenance interval ends. Please see https://documentation.red-gate.com/sm/adding-and-managing-monitored-servers/managing-monitored-servers/suspending-a-monitored-server for more details. If you would like to suggest any improvements around this area, please post your suggestions on the SQL Monitor Uservoice page at: https://sqlmonitor.uservoice.com/forums/91743-suggestions / comments
SQL Monitor does not provide such a list, however, the server will be identified as suspended on the "Overview" and "Monitored Servers" page.You can also schedule a "maintenance window" in which ca...
Hi Louis, You can overrule dependencies by disabling the IncludeDependencies SQL Compare option. You just need to add "-IncludeDependencies" as a SQL Compare option on the cmdlet. / comments
Hi Louis,You can overrule dependencies by disabling the IncludeDependencies SQL Compare option.You just need to add "-IncludeDependencies" as a SQL Compare option on the cmdlet.
Hi, Any monitoring issues will be highlighted on the "Overview" tab in the Dashboard. There are also alerts that will trigger if monitoring stops, for example: https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/metrics-and-alerts-reference/list-of-alerts#Listofalerts-Monitoringstopped(SQLservercredentials) https://documentation.red-gate.com/sm/metrics-alerts-and-notifications/metrics-and-alerts-reference/list-of-alerts#Listofalerts-Monitoringerror(hostmachinedatacollection) I hope this helps Sergio / comments
Hi,Any monitoring issues will be highlighted on the "Overview" tab in the Dashboard.There are also alerts that will trigger if monitoring stops, for example:https://documentation.red-gate.com/sm/me...