search

riezebosch / BoxstarterPackages

My wrongly named chocolatey packages repository. See the url for the AU results.
https://gist.github.com/riezebosch/78af415724ed3724701f732956900b2b
31 stars 34 forks source link

Cannot upgrade SQL-Server-Express #38

Closed Kuinox closed 2 years ago

Kuinox commented 4 years ago

Hello, Currently sql-server-express cannot be upgraded. Because the service run in background, the install script fail, and in the logfile i can read "Instance name 'SQLEXPRESS' is already in use. To continue, specify a unique instance name.".

By reading the docs, it looks like it's feasible to ugprade, but i need to look more into this: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15

If you don't plan to support upgrade, it would be nice to add a log in the console to say that it need manual upgrade.

riezebosch commented 4 years ago

That's correct. I never managed to create a decent uninstall script so you'll have to do that yourself. Should definitely be added to the package description.

Kuinox commented 4 years ago

I can't find how chocolatey do packages upgrade, but i think it's just calling the Install script.
Adding instances detection & running the upgrade script should be enough.
The big question for me, is, is it safe to update the sql instance.

riezebosch commented 4 years ago

As far as I'm aware it invokes the uninstall script of currently installed packages first.

Kuinox commented 4 years ago

Sadly i didn't found in the doc something specifying it, but i remember reading that it does behaved this way. By reading the logs, it looks like it's only running the install script now.