Posted by Erland Sommarskog on 11/11/05 00:36

Theo 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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Store data horizontally or vertically?
• Prev in forum: Re: Need security advice on xp_cmdshell, bcp, xml procedure
• Thread view: Re: migrating form standard to enterprise edition

[Reply to this message]