question

TonyStrother-2074 avatar image
0 Votes"
TonyStrother-2074 asked CyrAz edited

Migrate SCOM SQL 2012 databases to SCOM 2019, SQL 2019

Afternoon,

I cannot locate any clear info on this, so thought I would ask.
I would like to use a copy of our SCOM 2012R2, SQL 2012 databases in a new SCOM 2019, SQL 2019 build? That way I do not lose any data in my current environment, which would keep many, many users "happy"..
Is this possible to do??
Appreciate you assistance and time!
Tony

msc-operations-manager
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Also, how would I connect to this during the SCOM 2019 install?..

Thanks again,

Tony

0 Votes 0 ·
CyrAz avatar image
0 Votes"
CyrAz answered

You can't simply "re-attach" a SCOM 2012 database to a SCOM 2019 deployment.
If you want to keep your data, you need to run an in place upgrade from 2012 to 2016 and then to 2019.
It you do a side by side upgrade (new SCOM environment alongside the 2012 one), you can't keep your old data. Simple as that.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TonyStrother-2074 avatar image
0 Votes"
TonyStrother-2074 answered

Thank you for the info!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TonyStrother-2074 avatar image
0 Votes"
TonyStrother-2074 answered

So after I have done that, could I then build my new SCOM 2019 servers and attach to the database? Our environment is doing away with server 2012R2 so that would have to go.

Thanks,
Tony

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CyrAz avatar image
0 Votes"
CyrAz answered CyrAz edited

No, there is no supported way of "attaching a database from one environment to another", regardless of their version. Neither have I ever seen it documented anywhere.
Once again, the only supported way to keep your data is to keep your current SCOM 2012 deployment and upgrade it to SCOM 2019.
You can do that and update your environment to Windows 2019/SQL 2019 in the meantime, but that will require a bit of planification...

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.