deploy only a new schema as a separate database project without affecting existing production DB code
3
votes
1
answer
203
views
We have a production database (SQL Server 2019) with existing code (tables, procedures, functions, synonyms) that was deployed without a source repository. Our client wants to introduce a new schema with new code, but keep all the old code and data intact.
We plan to deploy the database changes via Azure DevOps pipeline - SQL Database Project in VS (new approach for all new changes and projects).
How do we create and deploy a database project solution that contains only the new schema and its related code, without including or modifying the existing database objects?
We want to avoid touching the old schema/code to prevent any risk or downtime. The new schema should be deployed independently, coexisting with the old schema and code.
What tools handle such partial database deployments?
How do we manage this in source control and CI/CD pipelines, especially considering the old code is not in a repo?
Asked by adam.g
(465 rep)
Jun 9, 2025, 06:28 PM
Last activity: Jun 17, 2025, 08:47 AM
Last activity: Jun 17, 2025, 08:47 AM