469,610 Members | 1,774 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

The most basic SQL Server questions....

ljh
(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.

May 30 '06 #1
3 1060
ljh,

The SQL Server data files, .mdf and .ldf files, cannot be used in a
standalone way, unlike Access .mdb files.

Your application must access these files attached to a running SQL Server.

Either SQL Server must be installed and running on the target pc, or the
target pc must be able to gain access to a running SQL Server via a network,
etc.

Kerry Moorman
"ljh" wrote:
(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.

May 30 '06 #2
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.

May 30 '06 #3
Express must be installed.
The setup you generate with VS2005 can detect and install it if necessary.
May 30 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Michael Foord | last post: by
7 posts views Thread by asfwa | last post: by
1 post views Thread by Wiktor Zychla | last post: by
3 posts views Thread by Miro | last post: by
6 posts views Thread by BJMurphy | last post: by
3 posts views Thread by JJ | last post: by
reply views Thread by =?Utf-8?B?SGVybWFu?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.