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

SQL Change Automation not finding objects in new schema

I've got a SQL Change Automation (SCA) project that is using a SQL Source Control repo as its source. I've just added all of the objects for tsqlt tests to my localDB and the repo and am attempting to create a migration to add those to the Dev server instance, but the addition of these objects is not being detected by SCA.

These objects are found when running SQL Compare between the source control repo and the same SHADOW db defined in the SCA job.

I do not have any filters set up on the SCA job that should be blocking the tsqlt schema.
87maxima
0

Comments

3 comments

Sort by
  • David Atkinson
    By default tSQLt objects are ignored by SQL Change Automation. 

    You can configure a setting in the .sqlproj to change this behavior:

    <!-- "Ignore tSQLt framework and tests" SQL Compare option --><SyncOptionIgnoretSQLt>True</SyncOptionIgnoretSQLt>

    See:
    https://documentation.red-gate.com/sca/developing-databases/concepts/advanced-concepts/comparison-and-script-generation-options

    Can you explain what the purpose of the Dev environment is? How does it fit into your pipeline?
    David Atkinson
    0
  • 87maxima
    Thanks David! I was unaware of that flag.

    So our pipeline is:

    Local Dev -> Shared Dev -> QA -> Staging -> Prod

    The purpose of the shared dev environment in question, it is the environment where multiple development teams deploy their parts of our projects (database dev, web API dev, web app dev, data warehouse dev, etc. etc.) its the first place all the teams' projects are built together as it is infeasible for all parts to be built in a local development environment.

    We are working on automating deployment of all pieces and once all are deployed want to run a set of automated tests to verify all pieces are working together as expected before we send anything over to the QA team.


    87maxima
    0
  • mr_gooding
    This helped me out too - i'd like the framework to be included for some (e.g. local dev / CI) but not all (production) environments, so this setting is useful. It's not very 'clear' for a beginner this though - i'd like to see this as an option in Visual studio and ideally in SSMS too on the road map for SCA (As configuration appears to happen in a few different places and at different levels of granularity)..
    mr_gooding
    0

Add comment

Please sign in to leave a comment.