How do i move an SQLDatabase to another location?
- From: "Tony Girgenti" <tony(nospam)@lakesideos.com>
- Date: Mon, 19 Mar 2007 15:48:42 -0400
Hello.
I realize my other post was a bit lengthy, so i'd like to repost this
question.
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.
After creating a new database from the VS server explorer, it seems that the
new database always resides in \C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data.
When i create the datasource, it asks if i want to copy it to my project.
If i answer yes, i cannot update the database.
How do i move the database to another location?
Any help would be gratefully appreciated.
Thanks,
Tony
.
- Follow-Ups:
- Re: How do i move an SQLDatabase to another location?
- From: William \(Bill\) Vaughn
- Re: How do i move an SQLDatabase to another location?
- Prev by Date: the insert s successful, but nothing changes in DB!
- Next by Date: RE: the insert s successful, but nothing changes in DB!
- Previous by thread: the insert s successful, but nothing changes in DB!
- Next by thread: Re: How do i move an SQLDatabase to another location?
- Index(es):
Relevant Pages
|
