What I’m trying to achieve is to generate an executable file from a script using the SqlPackager command line interface. The script file contains two parts:
1. The result script of a schema comparison (using SqlCompare)
2. A script file that contains code for inserting/merging static data.
I’m using a power shell batch to combine the files (extracting the content of the scripts and adding it to a new file one after the other).
I also tried packaging just the static data insertion script. The package raised SQL errors when I tried to execute it on the target database, as if the packager did not package the entire script.
1. Is it at all possible to create a package from a script which is not a schema script, i.e. a script which is inserting data to tables?
2. Is it ok to combine scripts textually and package them to one exe file?