Normally, to upgrade from FactorySQL to Ignition, you can just export your FactorySQL backup, and use the legacy upgrade tool in the gateway.
However, for various reasons, this can sometimes fail. This is especially true when Ignition is not installed on the same machine as FactorySQL. In this case, you may not have the .Net framework installed. Installing the .Net 2.0 runtime can help, but sometimes errors persist.
The process of upgrading a FactorySQL project consists of converting it to an XML file, and then importing the XML into Ignition. The tool to convert the file to XML can be run alone, and the XML imported manually. Generating the XML on the FactorySQL machine usually avoids any difficulty.
- Download and extract the tool from this link
- Run the ProjectConverter.exe app from the command line:
>ProjectConverter.exe old.fdb out.xml
ProjectConvertor.exe "C:\Program Files\Inductive Automation\FactorySQL\system_database.fdb" "c:\factorysql.xml"
- Take the XML file, and load it into the legacy upgrade tool in the Ignition gateway. The page says that it accepts FDB files, but it will also accept the XML.
Everything else about the upgrade will remain the same.