Migrate Tag History Data Post Migration of Windows/Tags to New Gateway/SQL Server

Ignition
1

Long title! :slight_smile:
I may have been a bit short sighted when I migrated some content from one server to another for a customer. In the effort we were tasked with moving a set of OPC tags and windows from one server (that was remote from the site) to a new site based server. My lack of foresight was in regard to the tag history data. So now the customer only has access to data back to when the content was migrated.

What would be the most effective and convenient method to migrate the tag history data from the original server to the new server? Both servers have their own MS SQL server and it would be preferred for the site data to be in the site SQL server.

Thanks,
Mike

2

Got this exact requirement too, what kind of solution did you find?

3

That's been a minute! :laughing:
If I recall correctly, we did not find a solution. The client decided it was not worth the effort.
Sorry I can't be of more help.

1 Like
4

No problem. I think it can be done if you keep track of old and new tagID's carefully, and do some direct SQL table manipulation.

1 Like
5

Did you ever find a solution for this? Having the same problem.

6

I recently had to migrate history from one server to another. Here are some good reference threads. There's more than one way to skin a cat but these threads should be helpful.

You can always call support to get help with fixing backend tables if you need to update those. I did.