NOTE: Be sure that all messages are processed in QIE. If the messages are in processing or if there are a large amount of errors and the DB is migrated, the messages will be lost!
1) If possible, export the entire configuration of QIE by going to Application >> Export Configuration >> Check the checkbox next to 'Qvera Interface Engine'. If this is not possible, make sure there is a recent backup that can be imported later in the process.
2) Stop QIE in the Service Manager.
3) Go into QIE Service Manager.
- Go into the Startup tab. Within Arguments, change the Dconnection.driver, Dconnection.url, and Dhibernate.dialect.
Example:
-Dconnection.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
-Dconnection.url=jdbc:sqlserver://{server}:{port,default=1433};databaseName={qie}
-Dhibernate.dialect=com.qvera.qie.persistence.SQLServer2008UnicodeDialect
4) Once the changes are applied, start the Service Manager again.
5) Import a backup from the previous day or the export that was done at the start of this process.
6) Once the import is complete, start up the channels that are needed.
