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

siard --> microsoft sql: Error executing query: ALTER TABLE ... ADD FOREIGN KEY

Open ibbenz opened this issue 1 year ago • 4 comments

Description: A siard file is loaded with dbptk into a Microsoft SQL Database. No error message occurs during the transfer, but in the end only 2 out of 8 tables are transferred. Only in the dbvtk.log the user can see, that an error occured during an ALTER TABLE query as a part of the automatic transfer process.

Steps required to reproduce the bug:

  1. Load the siard-file in dbptk
  2. Send to Live DBMS (Choose SQL)
  3. Notice in SQL-Database that only 2 Tables were loaded.

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

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

ibbenz avatar Sep 19 '22 08:09 ibbenz