Running SQL Package from VS2005 Windows Installer

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Running SQL Package from VS2005 Windows Installer

Postby james.taylor » Tue Mar 18, 2008 2:51 pm

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
james.taylor
 
Posts: 4
Joined: Tue Mar 18, 2008 2:32 pm

Postby Brian Donahue » Tue Mar 18, 2008 4:27 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby james.taylor » Tue Mar 18, 2008 7:00 pm

Thank Brian,

That fix worked a treat and all is good again.

Regards
james.taylor
 
Posts: 4
Joined: Tue Mar 18, 2008 2:32 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests