Feature request: yo team project types for SSDT(SQL Server database projects), SSRS, SSAS, SSIS

[kethahel99]

Seeing as VSTS and TFS are so versatile at dpeloying SQL Server project artefacts, it would be awesome to create these project types for yo team to simplify and get started with SQL Server DevOps pipelines using K8S/AKS, Azure SQL Database and onprem SQL Server, SSIS, SSRS, SSAS instances?

[DarqueWarrior]

K8s/AKS is being worked on by a group and they will be submitting a PR when they are done. As for SQL do you just want the ARM template to write up the SQL and the app so an empty DB? Or did you want a sample scheme? The reporting services is not currently ben looked up at. But if you wanted to take a crack at it and submit a PR let me know.

[kethahel99]

Hi @DarqueWarrior , thanks for the feedback. This is great news!
For SQL, I am up for both
ARM templates will work great for setting up an Azure SQL Database environment if it doesn't exist. This is great for standing up the IaaC, CaaC part.
But additional to this I'm more thinking of deployments to existing SQL Server, SSIS, SSAS and SSRS environments using the project deployment model (.dacpac, .ispac, .rspac, .aspac). So If we could create a yo team template for these it would be awesome as they could leverage off existing extensions in VSTS/TFS or deploying SSIS and DACPAC
I'd love to take a crack at it. This will kinda force me to learn how to create a generator.
Can I just create my own branch or do I have to fork?

Best Regards from South Africa!

[DarqueWarrior]

Just fork my repo and create a branch in your fork for the SQL stuff. When you are ready you submit a PR from your fork back to my repo. Good luck!

[kethahel99]

Will do. Thanks a lot!