Create sql change automation project from powershell
loris_braga
Posts: 1 New member
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
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
Tagged:
Answers
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com