Installing MSDE with a .NET App

[Huw Lloyd]

Can anyone point me in the right direction...

Im looking to include MSDE merge modules as part of my Windows application
installation but i dont know how to:

1. Find out what merge modules to include and where to find them
3. Once MSDE is installed I want to run SQL scripts against it so that the
database is created and built for use in my application

How do I use a Deployment Project to do this... is there a book or article
anyone knows that will help?

Thanks in advance

 

[msnews.microsoft.com]

Can anyone point me in the right direction...

Im looking to include MSDE merge modules as part of my Windows application
installation but i dont know how to:

1. Find out what merge modules to include and where to find them
3. Once MSDE is installed I want to run SQL scripts against it so that the
database is created and built for use in my application

How do I use a Deployment Project to do this... is there a book or article
anyone knows that will help?

Thanks in advance

Adding Merge Modules is easy as Right-clicking on the Project and doing it.
As far as running scripts, IIRC you'll have to start the SQL Server instance
manually. You can specify in your Setup project to have an external EXE
(that you write) run to do this unless you think of another way. You can
invoke OSQL.exe with the -i option to run a particular script.