Requirement is to run SQL scripts stored in Synapse Dev instance on subsequent PPE & PROD env. Please keep in minds following points:
-
In Synapse dev workspace, sql files are stored as .sql files
-
When pushed to repository, the files are stored as .json files.
-
During CD release pipeline the code flow through the env from dev to ppe and then to production.
-
But we also want to execute our sql scripts during release pipeline so that the changes in database would also flow through.
Please let me know how to do that.
