William
Mon Mar 19 15:47:09 CDT 2007
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C76A2D.16C17C00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Where you place your database (.mdf and .ldf) file(s) is up to you. If =
you use the VS UI tools, there are a number of defaults that kick in and =
(as you found) SQL Server uses it's own "favorite" place to keep =
databases--you aren't given a choice to pick your own location. SQL =
Server Express Edition adds even more options (and complexity) as it =
permits you to have a user-instance of SQL server with its own (another) =
copy of the database. Yes, you can choose to put your database in the =
project as well. As I illustrate in the book, you can end up with 6 or =
more versions of the database in minutes. While each of these database =
instances can be updated, it might appear that they are not due to the=20
I'm of the opinion, that one needs to decide on a deployment strategy =
before clicking through the defaults. You need to decide if you want to =
have a shared server-based database, one that's installed independently =
on the client or one that's associated with your project. How you manage =
these SQL Server servers and instances and the databases you create is =
really up to you. Do the VS IDE tools help? Yes, but not very much. SQL =
Server Management Studio gives you a lot more options and (thus) control =
over what gets built where and when.
hth
--=20
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no =
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest =
book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-------------------------------------------------------------------------=
----------------------------------------------
"Tony Girgenti" <tony(nospam)@lakesideos.com> wrote in message =
news:OOf5a%23laHHA.4788@TK2MSFTNGP04.phx.gbl...
> Hello.
>=20
> I realize my other post was a bit lengthy, so i'd like to repost this=20
> question.
>=20
> Developing VS2005, SP1, .NET 2.0, VB Windows form program on WIN XP =
Pro,
> SP2. It has a Dataset with two tables using an SQL 9.0 Server =
Express.
>=20
> After creating a new database from the VS server explorer, it seems =
that the=20
> new database always resides in \C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data.
>=20
> When i create the datasource, it asks if i want to copy it to my =
project.=20
> If i answer yes, i cannot update the database.
>=20
> How do i move the database to another location?
>=20
> Any help would be gratefully appreciated.
>=20
> Thanks,
> Tony
>=20
>
------=_NextPart_000_0008_01C76A2D.16C17C00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Where you place your database (.mdf and =
.ldf)=20
file(s) is up to you. If you use the VS UI tools, there are a number of =
defaults=20
that kick in and (as you found) SQL Server uses it's own =
"favorite"=20
place to keep databases--you aren't given a choice to pick your own =
location.=20
SQL Server Express Edition adds even more options (and complexity) as it =
permits=20
you to have a user-instance of SQL server with its own (another) copy of =
the=20
database. Yes, you can choose to put your database in the project as =
well. As I=20
illustrate in the book, you can end up with 6 or more versions of the =
database=20
in minutes. While each of these database instances can be updated, it =
might=20
appear that they are not due to the </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm of the opinion, that one needs to =
decide on a=20
deployment strategy <EM>before</EM> clicking through the defaults. You =
need to=20
decide if you want to have a shared server-based database, one that's =
installed=20
independently on the client or one that's associated with your project. =
How you=20
manage these SQL Server servers and instances and the databases you =
create is=20
really up to you. Do the VS IDE tools help? Yes, but not very much. SQL =
Server=20
Management Studio gives you a lot more options and (thus) control over =
what gets=20
built where and when.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>hth</FONT></DIV>
<DIV><BR><FONT face=3DArial size=3D2>--=20
<BR>____________________________________<BR>William (Bill) =
Vaughn<BR>Author,=20
Mentor, Consultant<BR>Microsoft MVP<BR>INETA Speaker<BR></FONT><A=20
href=3D"
http://www.betav.com/blog/billva"><FONT face=3DArial=20
size=3D2>www.betav.com/blog/billva</FONT></A><BR><A=20
href=3D"
http://www.betav.com"><FONT face=3DArial=20
size=3D2>www.betav.com</FONT></A><BR><FONT face=3DArial size=3D2>Please =
reply only to=20
the newsgroup so that others can benefit.<BR>This posting is provided =
"AS IS"=20
with no warranties, and confers no=20
rights.<BR>__________________________________<BR>Visit </FONT><A=20
href=3D"
http://www.hitchhikerguides.net"><FONT face=3DArial=20
size=3D2>www.hitchhikerguides.net</FONT></A><FONT face=3DArial size=3D2> =
to get more=20
information on my latest book:<BR>Hitchhiker's Guide to Visual Studio =
and SQL=20
Server (7th Edition)<BR>and Hitchhiker's Guide to SQL Server 2005 =
Compact=20
Edition=20
(EBook)<BR>--------------------------------------------------------------=
---------------------------------------------------------<BR></FONT></DIV=
>
<DIV><FONT face=3DArial size=3D2>"Tony Girgenti" =
<tony(nospam)@lakesideos.com>=20
wrote in message </FONT><A=20
href=3D"news:OOf5a%23laHHA.4788@TK2MSFTNGP04.phx.gbl"><FONT face=3DArial =
size=3D2>news:OOf5a%23laHHA.4788@TK2MSFTNGP04.phx.gbl</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> Hello.<BR>> =
<BR>> I=20
realize my other post was a bit lengthy, so i'd like to repost this =
<BR>>=20
question.<BR>> <BR>> Developing VS2005, SP1, .NET 2.0, VB Windows =
form=20
program on WIN XP Pro,<BR>> SP2. It has a Dataset with two =
tables using=20
an SQL 9.0 Server Express.<BR>> <BR>> After creating a new =
database from=20
the VS server explorer, it seems that the <BR>> new database always =
resides=20
in \C:\Program Files\Microsoft SQL<BR>> =
Server\MSSQL.1\MSSQL\Data.<BR>>=20
<BR>> When i create the datasource, it asks if i want to copy it to =
my=20
project. <BR>> If i answer yes, i cannot update the database.<BR>> =
<BR>> How do i move the database to another location?<BR>> =
<BR>> Any=20
help would be gratefully appreciated.<BR>> <BR>> Thanks,<BR>>=20
Tony<BR>> <BR>></FONT></BODY></HTML>
------=_NextPart_000_0008_01C76A2D.16C17C00--