Creating an Upgrade exe Package programmatically
Yes, you need to supply a template project. The template project, such as the one you find in the SQL Packager code templates folder, contains the code the runs the SQL statements produced by the SQLCompare and SQLDataCompare Engines. Packager's engine will compile the template package into an executable. Optionally it can save the package as a C# project, which is essentially the Packager code template with the SQL scripts added as resource (.resx) files.