What are the challenges you face when working across database platforms? Take the survey

Create sql change automation project from powershell

Hi everyone,
I'm quite new to SQL Change Automation tools. In my company, we usually create a sca project by the useful interface from SSMS.
As far as we need to move this activity to the script side (we are creating a NuGet template that will create c# projects of our usual stack), we need to retrieve the same result of the wizard (Set-up a new project - SQL Change Automation in SSMS - Product Documentation (red-gate.com)).
So, I know that Redgate provides us powershell cmdlet. But I don't really understand how to put them together.
So basically I need to:
- Create a sqlproj
- Setup the connection string
- Pass a filter (.scpf)

Thank you very much on advance


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Hi loris_braga,
    Thank your for your forum post.

    The SQL Change Automation (SCA) Powershell module doesn't have any cmdlets that would help with this: the SCA PS Module is meant for the CI\DC part of the process, not development
    For the Development stage the workflow is meant to be done interactively (i.e. manually using SSMS or VS), as a result we do not provide any tools that assist in automating this process.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.