Project

General

Profile

Actions
Copy link

Bug #79282

closed

SQL identities and IDENTITY_INSERT with doctrine on mssql server

Added by Johannes Goslar over 7 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2017-01-11
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

On mssql servers dumps/importing with preset ids will fail as IDENTITY_INSERT is not set/allowed by default.
E.g. #79143
If we want IDENTITY_INSERT we would need to write some custom integration to set it on the just the table be inserted into at the current moment as it can only be ON for one table at a time.
In general it is probably wiser to not rely on inserting ids or altogether move away from sql dumps for static data shipped by extensions/distributions.

Actions
Copy link

Also available in: Atom PDF