14,499 questions
azure devops tfvc ci\cd for sql server database that is on premise
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 43%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Spunny
366
Reputation points
Hi,
We have multiple sql server databases on premise and we want to implement CI\CD for database changes. DACPAC will not work for us because we have many cross database references in joins for databases.
Any suggestions for implementing CI\CD. We use TFSVC and not git for versioning.
Appreciate any directions, links or resources or guidance.
Thank you
SQL Server | Other
{count} votes
-
Abubakar Riaz 1 Reputation point2024-04-07T07:32:59.3633333+00:00 DACPAC has very limited functions, you might want to look for some third-party tools like Redgate and dbup if your queries got cross db references.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 77%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Richard Swinbank 527 Reputation points MVP2024-04-07T16:30:26.2033333+00:00 Can you say a bit more about why you can't use DACPACs? Do you mean that you can't use an SSDT project because of your cross-database references?
Sign in to comment
Sign in to answer