Migrating Historical Tag Data From mySQL to MS SQL Server

We are looking to migrate about a year’s worth of trended tag data from mySQL to a new MS SQL Server database and then from here on out have all new data for these tags be trended in the new database. Since Ignition has clearly added some very specific table names to the mySQL database to deal with historical data behind the scenes, do I need to copy these over exactly into the MS Sql database for everything to show up properly when I start changing the historical repository location?

The end goal would be to be able to have new data (After I repoint the historical repository to the new SQL Server) and old data (Data stored when the historical repository was on mySQL) for the same tag be visible in our trends seamlessly altogether as if it was always in the same database.

Do I have to copy everything manually, or is there a simpler way to do this migration and achieve the above desired result? Thank you for the help!

You should be able to migrate your database from MySQL to MSSQL. I did find this article, it may be of some use

msdn.microsoft.com/en-us/library … (v=sql.110.aspx

It would be a good idea to change the name of the MySQL database and then give the MSSQL database the same name the MySQL database used to have. The database connections within Ignition are referenced by this name.

The only issue I could see you running into is if you have queries that you have written. Not all queries work between MySQL and MSSQL, there are some variations. As long as you are aware of this you should be able to correct any “hiccups” you may run into.