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/04/01 06:34]
kopro [MsSQL: Run CzechIdM with MsSQL database] information about snapshot in databaase
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:adm:server_preparation|Server preparation]] and [[tutorial:adm:czechidm_installation|CzechIdM installation]] please do skip all the settings and setup related to database. The tutorial describes how to run CzechIdM with a Microsoft SQL Server. When following the tutorials [[tutorial:adm:server_preparation|Server preparation]] and [[tutorial:adm:czechidm_installation|CzechIdM installation]] please do skip all the settings and setup related to database.
Line 101: 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 <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