Way to share source code for few SSDT projects?
Background: We have common part of database structure which is base for our product, this part is customised for customers. So we may have many final structures with common part.
My current solution split each of this to two SSDT projects: core project and customisation project(which have reference to core).
This approach generates two separate dacpacks, which is not desired because It lead to two step deploy: core dacpac is used to create database and then customisation dacpac is used to update it.
I would like to generate only one dacpac generated for both parts. Therefore I’m looking for way to share code between ssdt projects.
I’m know solution with sharing single files as a links, but that lead to a lot of manual work, especially with many final projects.
I tried shared projects (used by Xamarin) but they are limited to C# and VB projects.
I’m looking for any suggestions.
Further investigation lead me to solution that satisfy my needs:
It is possible to configure publishing profile of SSDT deployment in a way that structures from reference projects are also deployed.
Three things needs to be done:
- Check option "Include composite objects" in publishing advanced settings. (See Picture)
- Referenced dacpacs need to be in same folder during deployment as deployed one.
- Post/pre deployment scripts defined in referenced in project arent executed, but easy workaround exists: post/pre deployment script of final project may include scripts from referenced project by using ":r" directive.
Important notice: it is not possible to deploy dacpack with that option via SSMS studio, it is possible via Visual Studio and sqlpackage.exe.
- Using where clause in Sql Server LEAD
- Combine overlapping date ranges
- Providing string variable into Dynamic SQL SELECT statement WITHOUT it being read as a column name?
- How to store geocoded address information into the database
- Truncate a DDL or DML command
- How can I find out what FOREIGN KEY constraint references a table in SQL Server?
- Why ISDATE() is returning 9996 as date?
- .NET 8 & SQL Server 2016 - Contains() throws error
- IsDate Function in SQL evaluates invalid dates as valid
- SQL Server - Value passes ISDATE() but fails to CAST as DATE or DATETIME
- Error when connecting to SQL Server in deno: 'cannot find module crypto'
- Multiple many-to-many and multiple one-to-one relationships in the same entities
- SQL Server DATEDIFF round up the YEAR difference. How to round it down?
- Path table to HTML treeview in SQL Server
- SUM and Decimal precision
- Parse TEXT datatype column to grab values based on TAGS
- How can I create a tar file in memory from several varbinary(max) columns stored in SQL Server using .NET native API?
- collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- Maintaining property order with get-member
- migrate data from MS SQL to PostgreSQL?
- Add multiple conditional values to one column
- Read Committed vs Read Uncommitted if both transactions do not rollback
- SQL YEAR(GETDATE())
- VIEW with NOLOCK but called without NOLOCK
- SQL Merge WHEN NOT MATCHED BY SOURCE THEN on filtered source and targed tables
- SQL obtain timestamps for end datetime row 1 and start timestamp row 2
- Tricky SQL update
- Remove Identity from a column in a table
- Return 1 if value is 0 without CASE statement
- Append string text based on pattern search SQL