Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
tutorial:adm:mssql_database_support [2019/01/29 08:16] kotisovam |
tutorial:adm:mssql_database_support [2019/05/06 11:53] kopro [Develop CzechIdM with MsSQL and a docker] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== MsSQL: Run CzechIdM with MsSQL database ====== | ====== MsSQL: Run CzechIdM with MsSQL database ====== | ||
+ | {{tag> sqlserver sql mssql install database supported drivers}} | ||
The tutorial describes how to run CzechIdM with a Microsoft SQL Server. When following the tutorials [[tutorial: | The tutorial describes how to run CzechIdM with a Microsoft SQL Server. When following the tutorials [[tutorial: | ||
Line 5: | Line 6: | ||
<note important> | <note important> | ||
+ | <note important> | ||
+ | |||
+ | ----- | ||
+ | ALTER DATABASE bcv\_idm\_storage SET READ\_COMMITTED\_SNAPSHOT ON; | ||
+ | |||
+ | ALTER DATABASE bcv\_idm\_storage SET ALLOW\_SNAPSHOT\_ISOLATION ON; | ||
+ | ----- | ||
+ | |||
+ | Otherwise you risk deadlock on database.</ | ||
===== Setup MsSQL with CzechIdM ===== | ===== Setup MsSQL with CzechIdM ===== | ||
Line 92: | Line 102: | ||
===== Develop CzechIdM with MsSQL and a docker ===== | ===== Develop CzechIdM with MsSQL and a docker ===== | ||
+ | Beware this is recommended only for develop. | ||
- | Run lasted MsSQL database (change SA-PASSWORD): | + | Run lasted MsSQL database (change |
$ docker run --name=test-mssql -e ' | $ docker run --name=test-mssql -e ' | ||
- | Copy the initial script (init script is described above, in our example the name of the script file is import.sql) | + | Copy the initial script (init script is described above. Just copy and create file with defined sql queries, in our example the name of the script file is import.sql) |
$ docker cp import.sql test-mssql:/ | $ docker cp import.sql test-mssql:/ | ||