Moving a database from SQL Server to MSDE

Hi,
I have created quite a large database project that the client now wants to
run locally for demo purposes.
What is the best (& easiest for non-programmer client) way to transport a
snapshot of this database from one to the other - with the data still
intact? The VS.Net tools appear to only move the structure and stored
procedures etc..
Thanks in adavance,
StuStu
I prefer BACKUP/RESTORE commands
"Stu Lock" <s.lock@.cergis.com> wrote in message
news:eCF$cGyyEHA.3336@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have created quite a large database project that the client now wants to
> run locally for demo purposes.
> What is the best (& easiest for non-programmer client) way to transport a
> snapshot of this database from one to the other - with the data still
> intact? The VS.Net tools appear to only move the structure and stored
> procedures etc..
> Thanks in adavance,
> Stu
>|||How do you restore an SQL Server database to an MSDE instance that has no
database installed?
THnx.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23B1asKyyEHA.3840@.tk2msftngp13.phx.gbl...
> Stu
> I prefer BACKUP/RESTORE commands
>
>
> "Stu Lock" <s.lock@.cergis.com> wrote in message
> news:eCF$cGyyEHA.3336@.TK2MSFTNGP11.phx.gbl...
>|||"Stu Lock" <s.lock@.cergis.com> wrote in message
news:%23gQ5rBzyEHA.2540@.TK2MSFTNGP09.phx.gbl...
> How do you restore an SQL Server database to an MSDE instance that has no
> database installed?
>
Same way you'd restore it to any SQL Server. RESTORE DATABASE foo from
disk='\\foo\bar\baz.bak'
BOL will have more details.

> THnx.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23B1asKyyEHA.3840@.tk2msftngp13.phx.gbl...
a[vbcol=seagreen]
>|||Just be aware of the limitations of MSDE. Maximum DB size is 2GB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:DVbmd.8248$qv5.8175@.twister.nyroc.rr.com...
> "Stu Lock" <s.lock@.cergis.com> wrote in message
> news:%23gQ5rBzyEHA.2540@.TK2MSFTNGP09.phx.gbl...
no[vbcol=seagreen]
> Same way you'd restore it to any SQL Server. RESTORE DATABASE foo from
> disk='\\foo\bar\baz.bak'
> BOL will have more details.
>
wants[vbcol=seagreen]
transport[vbcol=seagreen]
> a
>sql