Posts
Sort by recent activity
Installing PowerShell components?
I installed the PowerShell components from SQL toolbelt on my deployment server as it does not have internet access. The installer indicated it requires LocalDB 2014 64-bit. Is this really the case...
Use-DatabaseReleaseArtifact and snapshot creation
I have created a small use case script that will vary if the snapshot is inserted or deleted based on how the project object was created. If created with Invoke-DatabaseBuild the snaphot is insert...
New-DatabaseDocumentation
Can this PowerShell Cmdlet be used to create documentation outside of a database artifact? I would rather it not be embedded in a nuget or zip file with the deployment files.Thanks
warning : No schema snapshot could be retrieved from the target database?
I get warnings in my build and deployment scripts for this.warning : No schema snapshot could be retrieved from the target database; no report will be generated until your next deployment. If you c...
Manually change programmable objects?
Is it OK to manually change the programmable object scripts? I ran into an issue where I needed to alter a function which was used in a check constraint on a table. The only way I have been able t...
Manually change programmable objects?
Is it OK to manually change the programmable object scripts? I ran into an issue where I needed to alter a function which was used in a check constraint on a table. The only way I have been able t...
Powershell deployment slow?
Still learning and trying out SCA. Running the DeployPackage.ps1 it takes way longer than I would have expected. My database has 775 objects. I have 4 tables included with data that have less than ...
Order of scripts being run for deployments
Getting started with SCA and running into an issue:I needed to alter a function which was used in a check constraint on a table. In order to do this the constraint must be dropped, function altered...
Base Monitor Setup
Does the Base Monitor need to use the same credentials to update the RedGateMonitor DB and monitor the servers?
I initially set it up with my ID which has access to both. Now I changed the monitor ...
Service failed to start on install
Windows XP SP3
On install I am getting an error "Service 'SQL Monitor 2 Web Service' (MonitorWebServiceNetwork) failed to start. Verify that you have sufficient privileges to start system services....