search

DarqueWarrior / generator-team

Generates an app with CI/CD in Team Foundation Server or Team Services
MIT License
92 stars 51 forks source link

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

Open kethahel99 opened 6 years ago

kethahel99 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

Will do. Thanks a lot!