Deployment from command line?

BobC

I followed your TeamCity instructions here:

https://documentation.red-gate.com/sca3/automating-database-changes/add-ons/teamcity/use-the-teamcity-plugin-with-a-sql-change-automation-project

But for deployment it just talks about using Octopus (which we don't use) or to "check instructions for your release tool vendor". Could you point me to some instructions on how to deploy from the command line or PowerShell?

Thanks

Andrea_Angella

To deploy using PowerShell you can use the following cmdlets:

• New-DatabaseReleaseArtifact - to create the database release artifacts
• Use-DatabaseReleaseArtifact - to run the update script against the target database

You can find information on how to use them at the following address:
https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployments