Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
tutorial:adm:mssql_database_support [2019/05/06 11:52]
kopro [Develop CzechIdM with MsSQL and a docker] 		tutorial:adm:mssql_database_support [2020/06/03 14:00]
apeterova [Supported version of MsSQL]
Line 89: Line 89:
 ===== Supported version of MsSQL ===== ===== Supported version of MsSQL =====
   * **14.0** - 2017 SQL Server 2017   * **14.0** - 2017 SQL Server 2017
 +    * Tested version: 14.0.3294.2
 +    * Unsupported version: 14.0.1000.169 - contains a bug, which causes failure of the task DeleteExecutedEventTaskExecutor with the following error: ''SQL Error: 21, SQLState: S0001. Warning: Fatal error 605 occurred'', event viewer: ''Attempt to fetch logical page (1:604718) in database 5 failed. It belongs to allocation unit 72057594065387520 not to 72057594089439232.''
  
  
Line 102: Line 104:
  
 ===== 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> with your password): Run lasted MsSQL database (change <SA-PASSWORD> with your password):
    $ docker run --name=test-mssql -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<SA-PASSWORD>' -p 1433:1433 -d microsoft/mssql-server-linux:latest    $ docker run --name=test-mssql -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<SA-PASSWORD>' -p 1433:1433 -d microsoft/mssql-server-linux:latest
  
-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:/import.sql    $ docker cp import.sql test-mssql:/import.sql
  
  • by doischert