Has anyone had any experience converting a legacy GE iFix system database to an OSIsoft PI Data Historian? I am looking at less than 1,000 tags but maybe 15 years of data. Any tips, short cuts, or important information would be greatly appreciated.
I have, but too long ago to remember details. GE, is that the old "Proficy Plant Applications" Historian?
Typical approach would be using ODBC (OPC HDA as an alternative). I remember i used SQLServer Integration Services to get the data out of GE in batches of e.g. 1day, and into PI again using ODBC.
Experiment with technical options and their performance and use that to decide. It can be very dependant on a specific implementation. I remember in this case some hidden limitations you can hit when querying more data, longer periods, etc. So don't extrapolate but test your approach.
Retrieving data ...