Posts
Sort by recent activity
Best way to introduce SCA deployments to ops DBAs?
I have a license for the full SQL Toolbelt (heaven), but none of our ops DBAs currently have licenses. We also do not have a CI/CD technology in place. Our current process has devs delivering a s...
Partial project using table name prefix?
I have a DB that has a new set of tables for a new application. For some reason, the developers were not able to create the new objects in a new schema, so they are in dbo. All of the tables are ...
How can I get a SQL Change Automation deployment to be seen as non-drift?
I would like to integrate SQL Change Automation + DLM Dashboard (+ Bamboo + Octopus Deploy). For starters, I'd like to find a way for a known SCA deployment (from VS or CI/CD server) to be "unders...
How to populate dbo.__MigrationoLog.release_version column via powershell?
From a previous post, I learned that we should be able to populate the release_version column of the dbo.__MigrationLog. "If deploying via PowerShell, set the $ReleaseVersion
variable to populate ...
How does "Always use default connection string for Shadow database" work?
I want to ensure that my shadow database does NOT get created on target servers (esp QA and above). I see the "Always use default connection for Shadow database" and the ability to set the default...
Can we change the output of Changes.html to NOT included previous column with just a comma added?
When I add a new column to a table via SCA, and then generate Changes.html via New-DatabaseReleaseArtifact / Export-DatabaseReleaseArtifact, I see changes marked-up/highlighted for the existing col...
Are we restricted to only using alpha characters when using semantic version migration grouping?
I am attempting to use semantic version ordering for migration grouping. I want to add the name of our release, "2018_Aurora", to the version # 1.0.0 to make a final folder name of "1.0.0-2018_Aur...
How do I populate the __MigrationLog columns: version, package_version, release_version?
I am attempting to create a coherent vision of the various concepts of "version" and "release" using SCA and Bamboo. One area where I see possibilities is in the __MigrationLog table. Here, we ha...
What actions generate the schema snapshot required for drift and deploy preview reports?
I want to get clear on what activities ensure that I get drift and deploy preview reports. I'm currently executing New-DataBaseReleaseArtifact via PS script and get the following WARNING:"No schem...
How to use -Target <list> in New-DatabaseReleaseArtifact?
The docs for New-DatabaseReleaseArtifact discuss using a list of one or more items as an argument to the -Target parameter. When I tried to do that, I got: "to create a release for a SQL change aut...