How can we help you today? How can we help you today?

SCA, State and Migrations

I like to use Redgate's SCA  for  database builds, but I'm getting more confused by the documentation for SCA that is increasingly including examples and features (e.g. sqlcmd variables and component versioning ) that are only relevant to ReadyRoll and doing Migrations in Visual Studio. Can anyone please confirm that it will remain eclectic, and support conventional object-level scripts?
Phil_Fact0r
0

Comments

6 comments

Sort by
  • AlexYates
    Readyroll is now called SQL Change Automation too.
    AlexYates
    0
  • Phil_Fact0r
    Ah. Maybe I've misunderstood something. So what term now distinguishes the two parts of the tool, and tells me that, for example,  SQLcmd variables aren't supported for what I'm trying to do?
    Phil_Fact0r
    0
  • Phil_Fact0r
    I'd still be grateful to know whether SCA will remain eclectic, and support conventional object-level scripts as well as migration scripts?
    Phil_Fact0r
    0
  • AlexYates
    SCA projects have a couple of concepts which support this:

    - Programmable objects:
    https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-scripts-to-capture-database-changes/programmable-objects
    - Offline schema model:
    https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-scripts-to-capture-database-changes/offline-schema-model

    As far as I know these features aren't going anywhere - but deployment of tables and data is via the migration scripts. The offline schema model is basically a reference point, handy for spotting conflicts, but it is not used for deployment.

    If you would like to stick with with a purely state-based deployment process, use SQL Source Control for script management/source control, and the SCA powershel cmdlets for deployment. In this scenario SCA basically does a fancy SQL Compare job, through a PowerShell interface, with various handy features like drift detection and pretty deployment reports to support script review and static code analysis.
    AlexYates
    0
  • Phil_Fact0r
    I tried clicking the link but that is talking about Visual Studio, which I don't use. I have SQL Change Automation in SSMS. Does this do the same thing?  I've tried starting a workspace and putting a development database in it but I can't find a way of generating the object-level scripts (I think you call this the offline schema model)
    Phil_Fact0r
    0
  • Phil_Fact0r
    (Later) reinstalled the SCA  in SSMS in its latest version. This time it worked when one hit 'refresh'. and produced a scripts directory just like the good old days. I generally use SQL Compare for this, but this could be handy.
    Phil_Fact0r
    0

Add comment

Please sign in to leave a comment.