migrating form standard to enterprise edition

Hi,

Can someone tell me what the best way is to migrate from a SQL Server 2000
Standard Edition to a SQL Server 2000 Enterprise Edition?
Is this a migration possible from the setup program of the Enterprise
Edition?
What are the pitfalls?

Thanks in advance
Theo LinnenbankTheo Linnenbank (theo@.totalweb.nl) writes:
> Can someone tell me what the best way is to migrate from a SQL Server 2000
> Standard Edition to a SQL Server 2000 Enterprise Edition?
> Is this a migration possible from the setup program of the Enterprise
> Edition?

Yes. See Books Online, Installing SQL Server -> Upgrading an Existing
Installation of SQL Server.

> What are the pitfalls?

As a safety precaution, I would re-apply the latest service pack.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql