Installer Project

[tkemory]

I am trying to create a Windows Installer package, can anyone lend some advice on best route if my software needs to connect and deploy some stored procedures? Thanks in advance Terance Emory

[MultiThread]

Hi Terance, If your code needs to deploy items which don't already have .NET framework code to do so (i.e. message queues, etc.), you can add an installation component to your application which has callbacks that can act in the context of installing and uninstalling your application. If you use "Add new item..." to your project, you should find an installer class. This derived class has overrides you can use during the installation process to do work during the install, rollback, commit and uninstall portions of installation. MSDN online provides a walkthrough on how to create a database, the same example can be adapted to add your stored procedure to the database during installation. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vxwlkWalkthroughUsingCustomActionToCreateDatabaseDuringInstallation.asp Regards, Joe

[tkemory]

Thanks Joe, This looks like exactly what I needed many thanks