Background: We hare migrating from oracle to sql server. We have a LOT of stored procedures that live in packages. We have a lot of of packages as well. Packages usually are tied to a main application.
Question: Does anyone have any recommendations on how to migrate the stored procedures to SQL server in order to allow for continuous deployment preferably thru a azure devops pipeline.
Note: We were thinking DACPAC but if we need to only need to migrate a subset of the stored procedures to production and not all changes, can you do that? Is there a better way? Best way to keep in source control and change sets etc
Thoughts? thanks in advance. Any best practices some where?