We are using TFS and octopack successfully to build and pack up two web sites from our solution. In our repository is a folder of SQL files (created by Red Gate SQL Source Control). I would like to add these files into their own nuget package so they can be used for database deployments.
The goal is to use a specific tentacle to push the package to and execute from a command line SQL Compare to diff (from t the files and database) the target database and update it. I have all the pieces, I am just not sure if an additional package can be created from a directory during our build cycle. There is no project file associated with the database files, it is simply folder of the different databases.