Command line API questions

[Ransha]

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?
_________________
Ran Shani

[Brian Donahue]

Hi Ran,

Yes that shoudl be fine. Please let us know what errors you get. We have opened a support call for this already so if you have anything to send please respond to the email that we sent you when we opened the call.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521