Deploying SQL Server 2000 database on MSDE

Hi All,
I have done by development using SQL Server 2000 Developer Edition. How do I deploy the database in MSDE?
Regards.
Hi,
2 Methods
1. Backup the database in SQL 2000 developer edition (Backup DATBASE) and
copy to MSDE machine and Restore it (RESTORE DATABASE)
2. Detach the (SP_DETACH_DB) in SQL 2000 developer edition , copy the MDF
and LDF to MSDE machine and then Attach the database (SP_ATTACH_DB)
See the command usage in books online.
Note:
If your database size is > 2 GB then you cant restore or attach the database
to MSDE. MSDE allows a maximum 2 GB database size.
Thanks
Hari
MCDBA
"sm" <sm@.discussions.microsoft.com> wrote in message
news:2AF7E862-5006-43E8-A828-A6337E7D2870@.microsoft.com...
> Hi All,
> I have done by development using SQL Server 2000 Developer Edition. How do
I deploy the database in MSDE?
> Regards.
|||Thanks.
"Hari Prasad" wrote:

> Hi,
> 2 Methods
> 1. Backup the database in SQL 2000 developer edition (Backup DATBASE) and
> copy to MSDE machine and Restore it (RESTORE DATABASE)
> 2. Detach the (SP_DETACH_DB) in SQL 2000 developer edition , copy the MDF
> and LDF to MSDE machine and then Attach the database (SP_ATTACH_DB)
>
> See the command usage in books online.
> Note:
> If your database size is > 2 GB then you cant restore or attach the database
> to MSDE. MSDE allows a maximum 2 GB database size.
> Thanks
> Hari
> MCDBA
>
> "sm" <sm@.discussions.microsoft.com> wrote in message
> news:2AF7E862-5006-43E8-A828-A6337E7D2870@.microsoft.com...
> I deploy the database in MSDE?
>
>