Flatron Posted April 15, 2010 Posted April 15, 2010 Hi!I have to upgrade an MSDE instance to SQL Express 2005 programatically.When I run SQLEXPR.exe /qb UPGRADE=ALL INSTANCENAME=INSTNAME, the setup exits with exit code 0, so it claims that the process ended successfully, but the instance doesn't get upgraded (installer returns almost immediately after the prerequisite checks).If I run it without /qb, I find that I have to select the component to be upgraded manually on the screen you find here: http://technet.microsoft.com/en-us/library/cc966393.aspx Under "To perform an in-place upgrade from MSDE to SQL Server 2005 Express" step 7. Is there a command line switch to fix this problem? If not, is there any other way to upgrade an MSDE instance?Thanks
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now