dbptk-developer
dbptk-developer copied to clipboard
keeps
DBPTK Developer - library and command-line tool for execution of database preservation actions
Hi, in postgresql, the table column is defined as **character varying** In SIARD package it will become ``` Employee Name CHARACTER VARYING(2147483647) varchar true ``` This was discussed in #155....
If database is big and contains external files or many embeded LOB-s then the creation of SIARD can take days. The process can unexpectedly stop due to multiple reasons: disk...
Created SIARD from sakila, only added a custom query "SELECT r.rental_id, r.rental_date, s.first_name FROM rental r, staff s" The "test query" button resulted successfully and siard was also nicely created....
I'm trying to understand the options around views and whether or not to materialise them when creating a SIARD. For the broadest possible compatibility it is probably wise to materialise...
Description: This may be a duplicate of #399. Having created a SIARD package with externalised LOBs I wan't to convert the SIARD package back to a database. When the inserts...
Description: I'm working on an MSSQL database which (across several tables) has fields of type decimal(20,12). For values *x* in the range 1E6
Description: Cannot restore database: ERROR: column "OB_ID" specified more than once Call getNextException to see other errors in the batch. If I check the initial dbptk-report-20170126124051360.txt for creation with older...
One Latvian institution tried to convert their database into SIARD format. They faced a problem during conversion. Below is translated description of the problem. [dbptk-app.log.txt](https://github.com/keeps/db-preservation-toolkit/files/3515136/dbptk-app.log.txt) Information about database: SQL type...
To load the database it seems that I need to use the same filter options as for creating the SIARD file. But it is unconvenient to deal with --filter1-column-list additional...
When round-trip testing from MSSQLServer to SIARD and back, IDENTITY definitions are lost. Check if this is a problem or if IDENTITY (autoincrement) is not a significant property.
