search

sfa-siard / SiardGui

SIARD Suite - SiardGui
Other
17 stars 3 forks source link

Microsoft SQL --> SIARD: Loss of candidate keys #44

Open ibbenz opened 2 years ago

ibbenz commented 2 years ago

Issue: A Microsoft SQL database is converted into a SIARD-file by Siard Suite. The tables of the database contain primary, foreign and candidate keys. After the download/conversion into the SIARD-file the candidate keys do not exist anymore.

Process:

  1. Upload data from 0_1-3_Northwind_simple_220913_B.siard into a Microsoft SQL database
  2. Notice that the keys present in the SIARD-file were created in the Microsoft SQL database
  3. Download the data from the Microsoft SQL database into a file called 1.1b_1-3_Northwind_simple_220913_B.siard
  4. Notice that the candidate keys do not exist the newly created SIARD-file

SIARD file which was uploaded: 0_1-3_Northwind_simple_220913_B_dbptk.zip

SIARD file which was downloaded: 1.1b_1-3_Northwind_simple_220913_B.zip

walkerjan commented 2 years ago

Thanks a lot for reporting this issue.

We shall have a look at it and get back to you as soon as possible.

ibbenz commented 1 year ago

The loss of candidate keys occurs as well with SIARD 1.0 and SIARD 2.1 files.