Replacing the SQL script in C# customized project

Forum for users of SQL Packager database archive utility

Replacing the SQL script in C# customized project

Postby phoenixR77 » Tue Sep 08, 2009 9:37 am

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).
Posts: 2
Joined: Tue Sep 08, 2009 9:28 am

Postby Chris Auckland » Wed Sep 09, 2009 6:45 pm

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.
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Thanks Chris

Postby phoenixR77 » Wed Sep 16, 2009 8:30 pm

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.
Posts: 2
Joined: Tue Sep 08, 2009 9:28 am

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests