Package from script?

[ajs]

Is it possible to create a package from a script rather than pointing to a database? My database uses encryption and SQL Packager throws up over 200 warnings when I try to package my database. I have a script that I can use for installs, but I would like to wrap it up in SQL Packager. It seems my alternative is to manually generate the Package.resx files and import them in to the generated project.

Before I do that, is there another way?

[Brian Donahue]

Hello,

SQL Packager does not support reading a database from scripts, at least not yet. SQL Compare does, though, so I think it may be possible right now to use SQL Toolkit API to register a set of schema scripts as a database, register the data in the databases normally, and then use the Packager API to create an executable. This would all need to be done in C# or VB (.NET) code.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521