dbptk-developer icon indicating copy to clipboard operation
dbptk-developer copied to clipboard

siard-->microsoft sql: no candidate keys after conversion; no errors in dbptk.log

Open ibbenz opened this issue 1 year ago • 1 comments

Description: Candidate keys which were present in the SIARD-file are not created by dbptk during the process of loading the SIARD-file into the SQL-Database. Therefore, there are no candidate keys in the SQL database which were present in the SIARD-file.

Steps required to reproduce the bug:

  1. Load the attached .siard-file (zip) into a Microsoft SQL Database
  2. Notice that there are no key-related error messages in dbptk desktop or its log-file
  3. Notice that none of the candidate keys has been created in e.g. Tables "order details" or "categories"

Attach the dbptk-app.log.txt file below: dbvtk.log

The siard-file: 0_1-3_Northwind_simple_220913_B_dbptk.zip

ibbenz avatar Sep 22 '22 12:09 ibbenz