before anyone sends me links to Microsoft Docs about this subject, please read a bit more below.
I want to have a change management process with proper CI/CD on top of Azure Synapse Dedicated Database Pool.
What was tried:
Let's focus to Microsoft proposal:
I've Visual Studio enterprise with latest updates
Including Data Workload features
Connected to Synapse with success and imported existing data to it
Immediately tried to do a Build
Failed due to missing references on system objects
Adding master as database reference solved (this is a bug for me, but ok)
Tried a simple schema compare
Failed because of different source and target types
Database project assumed Microsoft SQL Server 2019 or Azure SQL Managed instance, Target of course is Synapse/Datawarehouse
Changed project to Target Datawarehouse, build immediately fails with unsupported data types and so many errors that I can't remember
Data types likes images, ntext, that I don't even use, but system views use,(Microsoft WTH ???)
Of course schema compare was not possible
Ok, let's try then to generate a publish preview... with no luck because of, previous points.
So, I was not even able to get to the CI/CD piece...
My perception, development is clearly not finished, and having a proper development environment that includes change management, that should be part of any MVP in a project, not happening here.
Synapse was released more than 1 year ago and we still don't have stable and fully development platform for it.
I hope someone here knows someone in PG, that can can actually answer to a simple question:
- How can one develop a change, build it with proper Target type and finally package it.
The CI/CD fortunately I can handle well.
Another thing I checked, this article...