We want to be able to run a migration (change data schema, seeding, etc) in a step against a database that is not publicly available. One way other CICD platforms achieve that feature is by allowing step execution in a remote agent (for example, an EC2 running in AWS that has ingress to the DB server). Is that possible within bitbucket pipeline?
Bitbucket Pipelines doesn’t have a first-party remote agent, but you might find a solution like AWS CodeDeploy to be useful in your scenario. You can use a Pipeline to upload an artifact to S3 and then invoke a CodeDeploy deployment. The CodeDeploy agent running on your EC2 would then download the artifact and apply it (do the schema migration, for example), and report the status back to the Pipeline run.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.