Running SQL Package from VS2005 Windows Installer
james.taylor
Posts: 6
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
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
Comments
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.
That fix worked a treat and all is good again.
Regards