KB344: How to migrate the Moxie Data Server from SQL CE to 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.

  1. Obtain the ExportSqlCE utility from Github here. (This utility is provided by a third-party and is not supported or maintained by Omnivex.)
  2. Extract the ExportSqlCE zip archive contents to a folder and navigate there.
  3. Make a backup copy of your backbone.sdf SQL CE file.
    • By default, this file is found in either
      C:\ProgramData\Omnivex\Moxie\Drive C\Program Files\Omnivex\Moxie\Data Server\DataServer\
      or
      C:\ProgramData\Omnivex\Moxie\Drive C\Program Files (x86)\Omnivex\Moxie\Data Server\DataServer\
      depending on which version of Moxie was originally deployed on the host.
  4. Copy your Moxie Data Server backbone.sdf SQL CE file into the extracted folder from step B.
  5. Open Command Prompt as Administrator and navigate to the extracted folder in step B. 
  6. In Command Prompt, execute the following commands:
    1. ExportSQLCE.exe "Data Source=Backbone.sdf;" MoxieSqlCe.sql
      • ​​This step will create one or more files called MoxieSqlCe.*, depending on the size of your database. 
    2. sqlcmd.exe -S SQLServerName\InstanceName -Q "CREATE DATABASE Moxie_Database"
      • ​​In this step, supply the hostname of your SQL Server machine, backslash (\), then the name of your SQL instance (if using multiple instances). 
    3. sqlcmd.exe -S SQLServerName\InstanceName –d Moxie_Database -i MoxieSqlCe.sql
      • ​​The above command uses MoxieSqlCe.sql. If multiple files were created in step F1, use this command multiple times to import all of the files.
  7. Run the Omnivex Moxie Data Server Config tool to point your Moxie Data Server to the SQL Server host and Moxie_Database database. 
  8. Complete the remaining Moxie Data Server Config steps and then start the Moxie Studio on your Moxie Data Server host to confirm that everything is running as expected.