Red Gate forums :: View topic - Modify created SQL
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Packager Previous Versions
SQL Packager Previous Versions forum

Modify created SQL

 Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
doblemente



Joined: 07 Dec 2007
Posts: 2
PostPosted: Wed Jan 02, 2008 7:17 pm    Post subject: Modify created SQL Reply with quote
Can I modify SQL before generate a .exe file ?
I want to create an Update package, It is possible?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
PostPosted: Mon Jan 07, 2008 1:59 am    Post subject: Reply with quote
Thanks for your post.

You can edit the SQL used in the Schema and Data scripts before the .exe is generated, but you will need to do this through a C# Project.

What you need to do is choose to output the package as a C# project, but make sure that you select to create the project with uncompressed resources. You can set this by unchecking the option 'Compress Generated SQL References' on the last step of the wizard. Once you have created the C# Project with uncompressed resources you will be able to edit the SQL through visual studio.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
doblemente



Joined: 07 Dec 2007
Posts: 2
PostPosted: Mon Jan 07, 2008 10:15 am    Post subject: Thank you Reply with quote
Many thank for your e-mail.

I do it and work fine.
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