Avatar of PAMurillo
PAMurilloFlag for United States of America asked on

What is the process to upgrade a database from MS SQL 2012 Express to MS SQL 2019 Standard ed for eMDs?

I have a client with eMDs Solution software running on a server and the database has maxed out at 10GB. Support say we need to upgrade to MS SQL 2019 Std or 2017 Std but do not offer support or instruction to upgrade. I am looking for a path to complete this process.  My client is currently not able to use the management software.


Any help would be appreciated!

DatabasesMicrosoft SQL Server

Avatar of undefined
Last Comment
PAMurillo

8/22/2022 - Mon
Seth Simmons

backup everything and do the install; you can upgrade directly from 2012 express to 2019 standard
cleaner, though, to do a new install of sql 2019 on a new server then export/import databases - less risk compared to doing an in-place upgrade.

Upgrades from Earlier Versions to SQL Server 2019 (15.x)

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15#upgrades-from-earlier-versions-to-

SQL 2019 also requires Windows 2016 or 2019 so if your 2012 instance is on an older windows version, will need to build a new server

Operating system support

https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-ver15?view=sql-server-ver15#operating-system-support
Scott Pletcher

If other than disk size, Express works for you, then it might be easier -- and will definitely be less costly -- to just spread the tables out over multiple dbs, each db <= 10GB, but the total size could be much more.  You can do this using synonyms, so the existing code would not have to change at all.
ASKER
PAMurillo

Thanks guys. I am more of a network admin/tech, not a DB guy so I am looking for the easiest path to gettting them working again.  

@Seth
Apparently the database will also work with SQL Std 2017. Would there be less chance of corruption with this version vs the bigger leap to ver 2019?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
PAMurillo

Follow up question. After Exporting/Importing in to the new SQL would I need to remove the origianl database from the old SQL Express. How would the software know where to look after the move?
Seth Simmons

Would there be less chance of corruption with this version vs the bigger leap to ver 2019?

wouldn't make a difference; any in-place upgrade comes with risk regardless if it is 2017 or 2019

Exporting/Importing in to the new SQL would I need to remove the origianl database from the old SQL Express.  

no need to do that; would suggest stopping the sql services or shutting down the server to make sure no systems are still talking to it

How would the software know where to look after the move?

you would need to update odbc connection to point to the new server and instance
another option would be to backup up all of your databases then remove the server from the domain and turn off
your new server could have the same name as the old one then after you restore, your clients should just connect though I have not tested that

ASKER
PAMurillo

Thanks Guys! In the meantime, someone at the office locked up the database by trying their own solutions. So it went from mostly working to not working for anyone. I had to do a restore and get them operational.

I am attampting to upgrade to MSSQL2017 and will let you know what happens
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
PAMurillo

@Seth
So when you mean Import and Export you mean using the SQL Server Import and Export Wizard, correct?

I muddled my way throught the process and was at the final part when I got this error message. Any advise?
ASKER CERTIFIED SOLUTION
PAMurillo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question