Would this work or does data get cached in connection for store & forward.
Have another MySql server up and going.
Duplicate databases and tables in it.
Stop ignition database connection, let store & forward store data.
Point database connection to new server and start up.
Let store & forward start pushing data in and get caught up.
Do any thing you may want to do to original database server, reset up and reverse process.
Will this work???
That should work. I don’t see any issues as long as you don’t rename the database connection. You shouldn’t have to do anything in the database either.
dberry1
December 22, 2017, 12:14am
3
How did it go? I’m about to try something similar. Do you have any advice?
I know it has been 6 years, but did you go through with this? Any advice from your experience?
I need to do this in Ignition 8.1, and it looks like it should still work the same.
Hello,
These steps worked for me. Store and forward collected the data until the new MySQL server was online then the data was saved to the database.
