SQL Packager Resources

eldi

Hello,

I intend to use SQL Packager to package Database creation and upgrades and had a couple of questions regarding the generated C# project since we will want more control on editing the SQL statements on the solution.

Why are the SQL statements packed in resource files? Do you have a method or tried before to use plain text instead?

Thanks for your help.

Daniel Handley

The recourse files contain the sql scripts. If you cannot read the contents it is because you have chosen to compress the package.

If you wish to edit the project / scripts before creating the executable you cannot use the "with compression" option.

Regards
Dan

eldi

Thanks Daniel I'm aware that the resource files contain the SQL scripts and they seem to be sepparated by the GO statements. I wanted to know if you have functionality to bypass the resource files and use plain text files for the scripts instead

Daniel Handley

Hi

Unfortunately not. You cannot point Packager at an external text file.

Regards
Dan