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.