Intel vPro® Platform
Intel Manageability Forum for Intel® EMA, AMT, SCS & Manageability Commander
2881 Discussions

Moving EMA Database

Rob_W
Beginner
1,083 Views

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

 

0 Kudos
6 Replies
MIGUEL_C_Intel
Moderator
1,067 Views

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


0 Kudos
MIGUEL_C_Intel
Moderator
1,004 Views

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


0 Kudos
Rob_W
Beginner
979 Views

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

 

 

 

0 Kudos
MIGUEL_C_Intel
Moderator
962 Views

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


0 Kudos
Rob_W
Beginner
954 Views
0 Kudos
MIGUEL_C_Intel
Moderator
943 Views

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


0 Kudos
Reply