AndrewSQLDBA (2/26/2010)
No, you would want to un-install the Express edition first, do not try to "upgrade". That is the very best way to approach this issue.You can create a backup of the databases, and then restore them on the prod box once SQL Server is installed.
Andrew SQLDBA
I get what you are trying to say here Andrew, but it is quite possible to upgrade Express to Standard, it is also quite possible to have the two exist on the same machine at the same time. Doing it you way creates a need for a substantial amount of downtime. Depending on the DB and the needs of the business this might be a serious issue. Also he'd need to recreate all of his security, maintenance plans, and other such things that just "happen" when you do an in place upgrade...
Best for you might not be "best" for someone else's environment.
-Luke.