I have been given the task of moving Ignition from and old server to a new server. I thought it would be a sensible idea to get some input on the process.
Main - 1 x Server running Ignition 7.9.6 & MSSQL
Backup - 1 x Server running Ignition 7.9.6 & MSSQL
Main - 1 x Server running Ignition
Backup - 1 x Server running Ignition
Main - 1 x Server running SQL
Backup - 1 x Server running SQL
install Ignition 7.9.14 on the Main & Backup.
Will I have Issues importing a 7.9.6 backup.gwbk into a Gateway running 7.9.14?
As we have an SQL DB attached. I am trying to work out the best way to swap over. while causing minimal downtime.
After I have copied the data from the old DB to the new DB, I was thinking to force fail over to the backup gateway which will be on the new Server and writing to the New DB, Then while the primary is offline I can swap it to the new servers.
I’m not familiar with MS SQL Server’s replication capabilities, but that’s where I’d look. When you are ready to flip the switch, you demote the old server to slave and promote the new server to master.