GMS SQL database migration to new server.

Ninad94

Hi Everyone,

We are going to migrate our GMS SQL database to new server. So just want to know what is the procedure for this migration. I do research on internet but haven't found any article for this.

Saravanan

@Ninad94 - Yes, using server name or FQDN in the old GMS server and also in the new GMS server should work with migration going smooth. Sorry for missing out this on the previous comment. But really appreciate you for asking the question.

Have a good one!!!

Sri

Hello @Ninad94

Thank you for reaching us on SonicWall communities.

Tagging our Subject Matter Experts for further assistance.

@Saravanan @shiprasahu93@Nevyaditha @Poorni_5

Saravanan

Hi @NINAD94,

Thanks for reaching out to us.

 Could you please confirm answers to below questions?

• Is your SonicWall GMS running on Windows or ESXi?
• What is your GMS version?
• Is your GMS implemented in a distributed deployment where you have a dedicated server for MySQL Database?

Please update us.

Ninad94

@Saravanan

Our GMS is running on windows.

Currently we are using 8.7 GMS version

Yes Our GMS is in distributed environment and we are have dedicated server for MySql database.

Saravanan

@Ninad94 - Thanks for the details.

If you are planning to use the same old MySQL server's IP address on your new MySQL server, then you can create a MySQL dump on the old server and import the same onto the new server. 

The migration unfortunately do not work if the new server is going to listen on a different IP address.

Hope that helps.

Ninad94

@Saravanan IP is going to change so instead of IP can we use server name..??

Ninad94

@Saravanan so in this case we have to replace local host as a host name instead of IP address in configsgms.xml file.

I am following below article.

https://www.sonicwall.com/support/knowledge-base/change-the-location-of-the-gms-database-sql-server/170502656371787/

Saravanan

@Ninad94 - Yes, you are right. You are using the right article.