Roundtrip testing dbptk using SIARD - keeps/dbptk-developer GitHub Wiki

SIARD formats 1, 2 and DK are supported by dbptk.

In order to test it, roundtrip tests are performed with the supported database engines:

1. A test database is created with cases to be tested: null values, default values, autoincrement, index, etc;
2. The database is uploaded to the engine to be tested;
3. The database is then converted from the engine to SIARD;
4. The SIARD instance is converted to a different database in the same engine;
5. Database dumps in plain text are generated;
6. The source dump is patched with previously set expected changes;
7. The patched source dump and the destination dump are compared.