Re: How do i move an SQLDatabase to another location?
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Mon, 19 Mar 2007 13:47:09 -0700
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
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
--
____________________________________
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@xxxxxxxxxxxxxxxxxxxxxxx
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: Tony Girgenti
- Re: How do i move an SQLDatabase to another location?
- References:
- How do i move an SQLDatabase to another location?
- From: Tony Girgenti
- How do i move an SQLDatabase to another location?
- Prev by Date: Re: Invalidate disconected recodset
- Next by Date: Re: How do i move an SQLDatabase to another location?
- Previous by thread: How do i move an SQLDatabase to another location?
- Next by thread: Re: How do i move an SQLDatabase to another location?
- Index(es):
Relevant Pages
|
