Move Test Link from MySQL to MSSQL

[Maje]

Hey,
We moved our Test Link system from a Solaris with MySQL database (Test Link Version 1.9.14) to an IIS with MSSQL database (Test Link Version 1.9.16).
Maybe someone wants to do something similar, so we decided to post the steps we did.

1. Install Test Link 1.9.16 on the IIS.

2. Downgrade Test Link MSSQL database to Test Link 1.9.14(Test Link Version of the MySQL database).

3. Created a MySQL dump of the old database with
mysqldump -u username -p --compatible=mssql --extended-insert=FALSE –complete-insert=TRUE -t database >file.sql

4. Change the dump to allow identity insert for tables with ids, remove quotes in table name, change paths for new upload area, replace MySQL wildcards (example \’’ with ‘’) and remove line endings. (We used a python script for this, if needed I could upload it too)

5. Convert the dump in the right charset for the new database. (UTF-16 LE did it for us)

6. Execute the SQL dump on the new Database.

7. Upgrade the database to the installed Test Link version. We needed to remove “CONSTRAINT” in the declaration of plugin_id and plugin_config_id in the /sql/alter_tables/1.9.15/mssql/DB.1.9.15/step1/db_schema_update.sql.

8. Copy the old upload area from the old Installation to the new one.

9. Test the new Installation.

If you have, any questions feel free to ask.