Options

SQL Packager Resources

eldieldi Posts: 3
edited June 6, 2005 12:12PM in SQL Packager Previous Versions
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.
· Share on Twitter

Comments

  • Options
    Daniel HandleyDaniel Handley Posts: 214
    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
    Daniel Handley
    Red Gate Software Ltd
    · Share on Twitter
  • Options
    eldieldi Posts: 3
    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
    · Share on Twitter
  • Options
    Daniel HandleyDaniel Handley Posts: 214
    Hi

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

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
    · Share on Twitter
This discussion has been closed.