topic Re: Re:Moving EMA Database in Intel vPro® Platform

Moving EMA Database

Rob_W — Thu, 14 Sep 2023 10:07:14 GMT

Hello,

is it possible to move the EMA Database to a different SQL server?

Can't find much information about this.

We're using Server 2019 and EMA is v1.9.1

thanks

Rob

Re:Moving EMA Database

MIGUEL_C_Intel — Fri, 15 Sep 2023 01:36:26 GMT

Hello, Rob_W,

Please give us more details of what you want to accomplish.

Do you want to change the current EMA database to a different SQL database? Are we talking about the SQL software version or location (computer)?

Will the admin user be the same?

Which SQL software version are you using?

Where is located (physical machine, virtual machine?

Include the operating system that is handling the current EMA database and the future.

Regards,

Miguel C.

Intel Customer Support Technician

Re:Moving EMA Database

MIGUEL_C_Intel — Tue, 19 Sep 2023 18:51:21 GMT

Hello, Rob_W,

I hope this post finds you well.

Please give us the answers to the questions below.

1- Do you want to change the current EMA database to a different SQL database? Are we talking about the SQL software version or location (computer)?

2- Will the admin user be the same?

3- Which SQL software version are you using?

4- Where is located (physical machine, virtual machine?

5- Include the operating system that is handling the current EMA database and the future.

Regards,

Miguel C.

Intel Customer Support Technician

Re: Re:Moving EMA Database

Rob_W — Thu, 21 Sep 2023 10:28:22 GMT

Hi Miguel,

we'd like to move the database to another server, both 2019.

Its currently installed on the same physical server as the EMA application in a DMZ.

So we'd like to just move the DB to another server which will be a virtual SQL farm.

The current EMA server and DB are in the DMZ and the new location of the DB will be hosted internally so we'd have to sort out ports to allow through the firewall as well. But the main question is, is it possible to move the DB to another server and reconfigure the EMA application?

SQL server 2017

Admin user will be the same.

thanks for your help.

regards

Rob

Re:Moving EMA Database

MIGUEL_C_Intel — Thu, 21 Sep 2023 19:54:27 GMT

Hello, Rob_W,

Thank you for your feedback.

It is possible to change the location of the EMA database. Please remember to keep a backup of the Database and the Mesh Settings Certificate (IIS) before making the changes. DMZ is not a restriction.

I am adding the article: Backup EMA SQL DataBase and MeshCertSettings outlined in the EMA installation guide section 1.4.1- Backup important Data. https://www.intel.com/content/www/us/en/support/articles/000091583.html

Regards,

Miguel C.

Intel Customer Support Technician

Re: Re:Moving EMA Database

Rob_W — Fri, 22 Sep 2023 07:50:43 GMT

Thanks Miguel

Re:Moving EMA Database

MIGUEL_C_Intel — Fri, 22 Sep 2023 15:08:12 GMT

Hello, Rob_W,

It was my pleasure; do not hesitate to reply if further assistance is necessary with the transition.

Regards,

Miguel C.

Intel Customer Support Technician