Posts
Sort by recent activity
Can I use WHERE clause to filter data?
In SQL Data Compare, I am able to set a WHERE clause on a table to filter data that I don't want in the comparison. I'd like to use this functionality in SCA to filter off local dev environment sp...
Is there a project file setting to remove the server name check?
At my company, there is a large wall between dev and ops. Ops DBAs want a single SQL script to use in all of their environments (anything above dev and qa). So, I have been taking the TargetedDeplo...
How can i access the current semantic version during build?
I am using semantic versioning for migration folder ordering. Ilike how it populates the version column in the __migrationLog table with the current/ latest migration folder name. I'd like to ac...
Populate release_version and/or package_version?
I'm now able to populate the release_version column in the __migration Log table via powershell using:$SqlCmdVersionVariables = @{ReleaseVersion = "1.1.0-build 1"}NewDatabaseRelease ... -SqlCmdVari...
Best way to handle starting SCA project from existing dev DB?
I've been running into some difficulties when starting a project from a DB that exists on a shared dev server and already has schema objects in it, then deploying via PS scripts to an empty DB (QA,...
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...