• subscribe
March 21, 2001 12:00 AM

Tip: Upgrade SQL Server Personal Edition

SQL Server Pro
InstantDoc ID #20246

I've seen many questions in the SQL Server newsgroups and other public forums about upgrading SQL Server Personal Edition to a full Standard or Enterprise Edition. Many of the responses have been needlessly complex. For the record, SQL Server Setup is a perfectly safe and supported method of upgrading one edition of SQL Server to another. If you need to upgrade SQL Server Personal Edition to SQL Server Standard Edition, simply run the setup program from a SQL Server Standard Edition CD-ROM. The setup program will make all the necessary registry changes. Running the setup program is painless and takes just a few minutes. To be sure about this answer, I ran it by reliable sources on the Microsoft development team and received their stamp of approval.



ARTICLE TOOLS

Comments
  • Anonymous User
    7 years ago
    Jan 19, 2005

    Same issue as Dave W. above. I believe that you cannot do a simple upgrade from the Personal edition to the Developer Edition. A new instance of SQL Server would need to be installed with a different server name is that true?

  • DAN
    8 years ago
    Oct 13, 2004

    Does this apply to upgrading/switching to Developer Edition? To try out Reporting Services on my development system, I have to have Development Edition (or Standard or Enterprise, but why waste the money) installed.

You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...