Options
Replacing the SQL script in C# customized project
phoenixR77
Posts: 3
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
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
Comments
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.
But your suggestion is far better
Thanks for your answer.
Radu