dbptk-developer
dbptk-developer copied to clipboard
keeps
DBPTK Developer - library and command-line tool for execution of database preservation actions
When round-trip testing from MSSQLServer to SIARD and back, the following changes occurred on the column data types: - `[bigint]` became `[decimal](19, 0)` - `[nvarchar](max)` became `[text]` - `[nvarchar](50)` became...
When round-trip testing from MSSQLServer to SIARD and back, triggers and stored procedures were converted into SIARD, but they were not converted back to MSSQLServer.
When round-trip testing from MySQL to SIARD and back again, and column type changed from timestamp to datetime, the value of the insert changes one hour, but it is possibly...
When round-trip testing from MySQL to SIARD and back again, AUTO_INCREMENTS are exported.
When round-trip testing from MySQL to SIARD and back again, foreign keys were not found on table definition.
When round-trip testing from MySQL to SIARD and back again, missing some DEFAULT declaration on column type definitions. Example, missing `DEFAULT ''`.
On round-trip testing from PostgreSQL to SIARD and back again, dates loose precision (milliseconds are lost). Example `2014-11-27 11:12:38.373` become `2014-11-27 11:12:38.37`. Other DBMS may also have this problem.
When round-trip testing from PostgreSQL to SIARD and back, SEQUENCES are missing. Check if this is a problem or if SEQUENCE is not considered to be a significant property.
Test the conversion of database contents (not just metadata)
The driver being used is sqljdbc4, version 4.0 which is not able to connect to MS SQL databases using windows integrated login (see #336). According to this [support & compatibility...