Replacing the SQL script in C# customized project

phoenixR77phoenixR77 Posts: 3
edited September 16, 2009 4:30PM in SQL Packager Previous Versions
Hi Redgate,
First of all I want to thank you for your toolbelt,it makes my life so much better :).
Second :
I am using SQL packager to deploy patches of our app,I customized the project in order to do other things besides patching the databases.

But now I want to keep the c# project and just change the SQL script it runs.
I see the the script is split inside the resource as a series of strings.
How can I replace the script in the project (generate the new resource strings) without creating a new packager project (I don't want to do the customizing all over again).


  • Thanks for your post.

    It's not really possible to replace the SQL resources within the same C# project. However, you could make the same customizations you made to the C# project to the SQL Packager code templates.

    This would mean SQL Packager will create the packages based on your customized project, rather than the default.

    I would recommend making a copy of the original code templates, in case you want to revert to the default behaviour.

    The code templates can probably be found in:
    C:\Program Files\Red Gate\SQL Packager 6\SQL Packager Code Templates

    I hope this helps.
  • I already had a method of generating new SQL resources by just replacing the resx files in my project with ones generated by creating new packager projects.

    But your suggestion is far better :).

    Thanks for your answer.
Sign In or Register to comment.