Jarvis was built as a way to manage static data files for automated database deployment with SqlPackage. Static data deployment is still in progress by Microsoft, and as yet is not supported.
Jarvis parses static data files created using generate-sql-merge and provides a nice interface for modifying the data. Some features include automatically detecting data types while editing, updating edit time stamps, and more.
Static data merge scripts can be added to the PostDeployment.sql file in the database project (see SQLCMD).
PostDeploy.sql
-- Include static data
:R _Data\Static\All\Schema.Table.sql
...
Create a normal database project using Visual Studio, and then add a _Data/Static/{Environment}
folder to the project to store static data files. Files can be organized in subfolders which represent different environments.
- Database Project
- _Data
- Static
- All
- Schema.Table.sql
- Development
- Test
- ...
- All
- Static
- _Data
Static data files are built using merge scripts created with generate-sql-merge. Simply insert the output from that query into the sql file for the desired table.