Replacing the SQL script in C# customized project

phoenixR77

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,
Radu

Chris Auckland

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.

phoenixR77

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.
Radu