Summary

An application created internally by bluetelligence to migrate data from an SQLite database to SQL Server.

Use case

You have started testing with a local SQLite database and have created templates and Scenarios and started working productively.
Now you want to move to a central SQL Server database without having to recreate your previous work.

Requirement

Performer Suite v20.2
SQLite database v20.2 (Source)
Empty database SQL Server (Target)

Limitation

The target SQL Server database must be empty.
You have to choose: Data from only 1 (one) SQLite database can be migrated to the new SQL Server database.
- You cannot write multiple SQLite databases to the same SQL Server database.

Where to get the tool?

Email us support@bluetelligence.de
(The tool is currently not public.)

Step-by-step guide

Place this migration tool as close as possible to your (target) SQL Server database to reduce latency and allow the tool to establish a stable connection to your SQL Server database.

If you need assistance, please ask your database-admin.

(Source) Browse for your SQLite Database
(Target) Enter your (SQL Server) Name (not the database name)
Select your SQL Server Authentication
If necessary, enter your SQL user credentials (User name + Password)
Enter the name of the empty SQL Server database
Press Start Import (duration: 5-30min, depending on your SQLite database size)

Note

After your migration, please test various functions in your Performer Suite and let us know if anything unexpected happens.

Troubleshooting

If the migration fails-- please send us:

application.log
screenshot of your entire screen, as soon as the migration fails

You can always send us your current SQLite database.
We will analyze what could be the issue and repair your SQLite database for your successful migration.

Browser not supported