Red Gate forums :: View topic - Running SQL Package from VS2005 Windows Installer
Return to www.red-gate.com RSS Feed Available

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

Running SQL Package from VS2005 Windows Installer

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



Joined: 18 Mar 2008
Posts: 4

PostPosted: Tue Mar 18, 2008 2:51 pm    Post subject: Running SQL Package from VS2005 Windows Installer Reply with quote

I have SQL Packager 5.4 and created a new install package for my database which updates older versions of the database.

Along with the latest database modifications, the VB.Net application that links to it has been upgraded to match the new schema changes.

I have an Windows installer written using VS2005 which has a 'Custom Action' that i would like to use to run the package created by SQL Packager.

I can get the windows installer to run the SQL package, however it does not complete the installation, it only runs the initial batch file window and closes.

If i goto the installed location on the target pc i can run the package and it works fine.

Are there any commandline arguments i need to use to allow it to run while another installer application is running?

regards
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6577

PostPosted: Tue Mar 18, 2008 4:27 pm    Post subject: Reply with quote

Hi James,

Depending on the location you run the Packager from (ie SUPPORTDIR), the package executable may get renamed to a 'temporary' file name during deployment. Packages can't normally be renamed as there are hard-coded resource names inside the assembly. There is a discussion and a workaround available from this link.
Back to top
View user's profile Send private message
james.taylor



Joined: 18 Mar 2008
Posts: 4

PostPosted: Tue Mar 18, 2008 7:00 pm    Post subject: Reply with quote

Thank Brian,

That fix worked a treat and all is good again.

Regards
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