KB363: How to migrate Moxie's database from SQLite to SQL Server
Note: Before beginning this process, ensure there is no pre-existing Moxie_Database on your SQL Server.
We've detected that you're using Internet Explorer version 7 or earlier. This site is not compatible with this version of Internet Explorer. This site is compatible with IE8 and up.
Note: Before beginning this process, ensure there is no pre-existing Moxie_Database on your SQL Server.
Note: As of July 2021, Microsoft no longer supports SQL CE
Prior to making any changes to a Moxie Data Server host, Omnivex recommends performing a complete backup of your configuration. If hosting the Moxie Data Server in a virtual environment, a snapshot of the VM is recommended. Otherwise, backup instructions can be found here.
Summary
SQLLink 3 supports any ODBC-supported database. In order for SQLLink to be able to read the data returned from your ODBC database, it must be formatted in plain text.
SQLLink 4 supports any Oracle, Microsoft SQL Server or ODBC-supported database.