Can I use SQLExpress database in App_Data in SQL2005 stand-alone box?

[GS]

Hello,

I use SQL express database on my workstation under App_data directory for development. I also want to use it in staging enviroment where SQL 2005 full blown version is installed.
Can I just copy database and use the same connection string to connect to it?

Greg

 

[Nanda Lella[MSFT]]

You should be able to that with out any issues.
Make sure that the databases does not have the same name.

--------------------

From: "GS" <[email protected]>
Subject: Can I use SQLExpress database in App_Data in SQL2005 stand-alone box?
Date: Wed, 18 Jan 2006 22:18:42 -0600
Lines: 44
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_000A_01C61C7D.23EEF370"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: dsl081-112-022.dfw1.dsl.speakeasy.net 64.81.112.22
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.framework.aspnet:371982
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Hello,
I use SQL express database on my workstation under App_data directory for

development. I also want to use it in staging enviroment where SQL 2005
full blown version is installed.

Can I just copy database and use the same connection string to connect to it?
Greg

--

Thank You,
Nanda Lella,

This Posting is provided "AS IS" with no warranties, and confers no rights.