This article describes how to complete a data pump from a SQLite database to a MS SQL database. 

Prerequisites

  • Server and database compatible version of the swDatabaseManager tool
  • The SQLite database file to be copied
  • Sole access to the SQLite database
  • An MS SQL database with SystemWeaver tables created (see Creating SystemWeaver Tables instructions below). Note that the MS SQL database must be empty, i.e., not contain existing data.


Note: The swDatabaseManager application is not for general distribution and should only be used by an authorized system administrator.


Confirming SQLite Database Version

Before getting started, verify the version of the SQLite database. You will need to know this for creating the new database.


Creating SystemWeaver Tables

Next, you will need to create the SystemWeaver tables in the MS SQL database. 


Note: In the User and Password fields, you must enter the credentials of an account that has sufficient db permissions to the MS SQL database in order to create the tables. If the Windows domain account you are using has sufficient permissions to the MS SQL database, you can leave the fields blank.


  1. Select Type=MS SQL Server and enter the name of your MS SQL database using the syntax host name|database name in the Select database field. Example: sys-lab-04|swdb
  2. To create the SystemWeaver tables in your new database, click the appropriate Create empty vX.XX button.The log window to the right will indicate when the creation is finished by displaying the version number information at the end.

  3. Verify the SystemWeaver version of the MS SQL database by clicking Display Info.

Copying the Data

  1. Navigate to the DataPump tab.
  2. In the From section: 
    • Select Type=SQLite.
    • In Name, enter the path and file name of the SQLite database that is being copied.
  3. In the To section: 
    • Select Type=MS SQL Server. 
    • In Name, enter the host name and database name of the MS SQL database using the syntax host name|database name. Example: sys-lab-04|swdb
    • In the User and Password fields, you must enter the credentials of an account that has sufficient db permissions to the MS SQL database in order to copy the data. If the Windows domain account you are using has sufficient permissions to the MS SQL database, you can leave the fields blank.
  4. Click the appropriate Copy Database X.XX button. The log window to the right will indicate when the copy is completed.


Note: The duration of time needed to copy will depend on the size of the database and the network latency between the SQLite file and the MS SQL server. To remove the latency factor, place the SQLite database file on the MS SQL server. Progress can be viewed in the admin of the MS SQL server, i.e., you can see that the rows are increasing.


Once the copyover is completed, you are ready to start a SystemWeaver server against the new database.


Troubleshooting

Error

"[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0][SQL Server]SHUTDOWN is in progress. The insert/update of a text or image column(s) did not succeed."


Resolution

It may be an issue with the version of the ODBC driver on the machine where the swDatabaseManager is located. Try upgrading to Microsoft® ODBC Driver 13 for SQL Server® - Windows (https://www.microsoft.com/en-us/download/details.aspx?id=50420) or later version to resolve the issue.  


After upgrade to version 13: