You cannot ship SQL Server Developer Edition with your application to users.
Yes, you must have SQL Server Express installed. Then you need to create the
database your application requires on the SQL Server Express. You can either
wirte SQL script to create it, or ship the database file (*.mdf/*.ldf files)
to the user and and attach the database files to SQL Server Express. With
SQL Server Express, you can also use "User Instance". In this case, you can
use code to attach database files to SQL Server Express dynamically. To
user, it seems, as if your app is only work with database file.
You can make your app intallation package to handle SQL Server Express setup
(quite complicated). I'd prefer install SQL Server Express seperately.
"ljh" <So**@where.else> wrote in message
news:q%******************@bignews8.bellsouth.net.. .
(sorry if this posts twice....I waited several hours and didn;t see it -
so here it is again.....)
Perhaps I am somewhat dense.....but, I still need to know.....
What do you need to do in order to ship a SQL server Express or Developer
edition database with your Visual Studio .Net 2005 application?
Does SQL Server Express need to be installed on the target machines? Or,
can the database file be used as a stand-along databse (like an Access
database)?
Books on SQL Express and VS 2005 Database programming abound (I have 4 of
them) - but these simple ehings do not seem to be covered.