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

[ibbenz]

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

[hmiguim]

The database user has the correct permissions?

[ibbenz]

Meanwhile I checked the permissions of the user/login "testlogindbptk"
This was the login/user which I created for the upload siard-->microsoft sql.

In order to check, if the user has the permission to alter the tables, I did the following:

1. I log into the Microsoft SQL Server Management Studio
   as user "testlogindbptk"
2. I create a table with two columns which are used as primary and foreign key.
3. I create the primary and foreign key.

I captured the process in the attached video:

Permissions_Microsoft_SQL_Studio.mp4

[hmiguim]

Hi,

Manage to find the problem:

SQL Error [8111] [S0001]: Cannot define PRIMARY KEY constraint on nullable column in table 'Customers'.

However due to the way DBPTK works it executes the prepared statements in batches making the errors not so obvious.

[ibbenz]

Thank you. I have changed accordingly key-relevant columns from _true to false. Now the tables are correctly imported from SIARD into SQL.