Sunday, March 25, 2012

Database from 2000 Enterprise Edition to std

Hi, There,
I want move the database from 2000 Enterprise Edtion to 2000 Std, does Ms
sql support that and any special way required?
Thanks and regards
ShermaineShermaine,
backup and restore should be fine. The only things I can think of to look
out for are:
if you use distributed partitioned views you will have to change them
if you use indexed views, your related queries will need to have the
"noexpand" hint added.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||You can also try to do a detach and attach the database.
"xiaomei" wrote:

> Hi, There,
> I want move the database from 2000 Enterprise Edtion to 2000 Std, does Ms
> sql support that and any special way required?
>
> Thanks and regards
> Shermaine|||Thanks too much, Paul, Lucas. Have a nice weekend!! .
"Paul Ibison" wrote:

> Shermaine,
> backup and restore should be fine. The only things I can think of to look
> out for are:
> if you use distributed partitioned views you will have to change them
> if you use indexed views, your related queries will need to have the
> "noexpand" hint added.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>

No comments:

Post a Comment