Posts
Sort by recent activity
How can I configure SCA to script index options with ONLINE = ON and SORT_IN_TEMPDB = ON?
I have created indexes in my dev DB with (ONLINE = ON, SORT_IN_TEMPDB = ON, FILLFACTOR = 85) options per ops DB standards, but when I refresh the SCA project, it does not include those options in t...
How can I tell the version of each lifecycle database using SSC?
With SCA, I can use the __MigrationLog table and its columns like Version, PackageVersion, and ReleaseVersion to see all of the changes applied to a lifecycle DB (dev integration, QA, UAT, prod) al...
How do I tell SCA to not attempt to download from the powershell gallery?
I was demonstrating SCA today without an internet connection. It showed the warnings below. How can I tell SCA to skip DL and use the currently installed versions?
WARNING: Network connectivity m...
Checksum warnings - "this migration has changed since it was deployed"
I'm seeing a ton of warnings in the output for New-DatabaseReleaseArtifact that say:"WARNING: C:\[...]\AppData\Local\Temp\DLM Automation\ifp4iatf.30a\Migrations\1.1.0-Changes\014_20190314-1432_[......
SCA Powershell Extension Plugins?
As I work with SCA, I find myself collecting a bunch of PowerShell scripts to extend the functionality. For example, I have one that takes a series of rollback scripts and concatenates them in rev...
Best practices for SCA deployments in a Oracle GoldenGate replication topology
I recently ran into some issues with production deployment of a SCA patch script. The deployment script was "rejected" by our ops DBAs because it contained a mixture of DDL and DML that affected t...
SCA on Jenkins Linux Node?
Is it possible to use Jenkins on linux for SCA CI/CD? From what I understand, SCA will only work on a Jenkins node that is running on a Windows OS. Can anyone confirm?
"Finish setting up project" keeps popping up even though I have set up the project DBs
SCA v 3.0.19085.6348I created a new SCA project, connected to an empty localhost DB as development and nothing as target. There are no migrations yet, but I did create a 1.0.0-InitialRelease folde...
How do I get tables to show up in the project object explorer?
In my SCA projects, when I open up the view "SQL Server Object Explorer", and then the "Projects" folder, and my current project, I don't see any tables even though there are many tables in my proj...
PackageScript.sql - questions: ReleaseVersion and PackageVersion and commented sqlcmd vars
This is a follow-up to my previous post: https://forum.red-gate.com/discussion/84832/is-there-a-project-file-setting-to-remove-the-server-name-check#latestIn build artifacts (nupkg archives), I'm n...