Converting a SQL Database to MSDE

Ok, I've got the tables created, the proc's created (and they work) and
everything else is done on the backend. My question is how to do I get
everything I've created in the database using a full version of SQL into an
MSDE database that I can distribute to my userbase so they can play. Someon
e
said all I need to do is a backup and restore -- but I'm not sure how it
would be done. Can anyone help?Backup and Restore is all you need.
Backup the database to a flat file
Restore onto MSDE using the flat file.
I would use SQL Enterprise Manager...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MisterB" <MisterB@.discussions.microsoft.com> wrote in message
news:65AA739F-3DA8-4CEF-813D-E8E4AFD95DAD@.microsoft.com...
> Ok, I've got the tables created, the proc's created (and they work) and
> everything else is done on the backend. My question is how to do I get
> everything I've created in the database using a full version of SQL into
an
> MSDE database that I can distribute to my userbase so they can play.
Someone
> said all I need to do is a backup and restore -- but I'm not sure how it
> would be done. Can anyone help?|||"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23V6IM1p7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Backup and Restore is all you need.
> Backup the database to a flat file
> Restore onto MSDE using the flat file.
> I would use SQL Enterprise Manager...
Note that the datafile will need to be less than 2 gigabytes.

> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "MisterB" <MisterB@.discussions.microsoft.com> wrote in message
> news:65AA739F-3DA8-4CEF-813D-E8E4AFD95DAD@.microsoft.com...
> an
> Someone
>|||How do you reattach the file(s) you backed up to the MSDE?
"Wayne Snyder" wrote:

> Backup and Restore is all you need.
> Backup the database to a flat file
> Restore onto MSDE using the flat file.
> I would use SQL Enterprise Manager...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "MisterB" <MisterB@.discussions.microsoft.com> wrote in message
> news:65AA739F-3DA8-4CEF-813D-E8E4AFD95DAD@.microsoft.com...
> an
> Someone
>
>