Red Gate forums :: View topic - Replacing the SQL script in C# customized project
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Replacing the SQL script in C# customized project

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
phoenixR77



Joined: 08 Sep 2009
Posts: 2

PostPosted: Tue Sep 08, 2009 10:37 am    Post subject: Replacing the SQL script in C# customized project Reply with quote

Hi Redgate,
First of all I want to thank you for your toolbelt,it makes my life so much better Smile.
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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Wed Sep 09, 2009 7:45 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
phoenixR77



Joined: 08 Sep 2009
Posts: 2

PostPosted: Wed Sep 16, 2009 9:30 pm    Post subject: Thanks Chris Reply with quote

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

Thanks for your answer.
Radu
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group