I have a BIDS
SQL Server Database Project with a database that I publish dynamically to various servers (SQL2016). It initially starts blank and everything is parameterized. Everything is in Azure DevOps and deploys to places.
I want to include/pack in (mostly static) configuration data for a few tables. Initially I used the script wizard to script the tables, then just put that script text in my post-deployment file (
I've come across one config table, when scripted, is a nearly 600mb script. The size isn't the problem, it just seems like there must be a proper/better way to embed it in the project.
Some things I've tried:
- Export to flat file and embed somehow. - Seems messy and I have to figure out a way to import it in my post deployment script
- Export single table bacpac - Doesn't seem to work because it tries to include entire database
- Use Script wizard to generate a giant
*.sqlfile. - I can add to the project and reference with SQLCMD
:r. Seems odd.
Is there some sort of data package dacpac/bacpac-style file that can wrap everything up nicely and can be easily imported? Perhaps compressed too?