deploying database files

[lord.zoltar]

Hi,
I'm wondering how I deploy a database with an application.
I know that I can require SQLServer Express to be installed, using the
ClickOnce deployment system, but I also need to know how I can include
the database files and have them installed into SQLServer Express as a
part of the installation process.
I'm running VBExpress, SQLServer Express (but I also have access to SQL
Server 2000, full version).

thanks.

 

[Dave Sexton]

Hi,

I'm not too familiar with the Sql Server Express edition, but aren't the databases .MDF files?

If your using an installation project, add the .MDF file to the Application folder. I assume that Sql Server 2005 Express has a
merge module or redistributable file that you can include in your installation.

If your using ClickOnce (as it sounds), go to the publish tab of your project's properties window and click the "Prerequisites..."
button. Check the "Create a setup program to install prerequisite components" checkbox and check Sql Server 2005 Express Edition in
the list. OK that dialog and click the "Application Files..." button. If your .MDF is not included already, include it (you might
have to check "Show all files").

HTH