example_sqlserver.md

SQL Server Example

• Back

Load database

1. Launch docker database

• docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=yourStrong(!)Password" -p 1234:1433 -d mcr.microsoft.com/mssql/server:2019-latest

1. connect to database in SQL Server Management Studio (SSMS) or Azure Data Studio
   • user: sa
   • password: yourStrong(!)Password
   • server: localhost,1234
2. create database NOT NEEDED

   create database mermaidToSql

3. Restore backup
   • download AdventureWorksLT2019.bak that corresponds with mssql 2019
   • copy into sql server docker machine docker cp ./AdventureWorksLT2019.bak containerName:/
   • run restore from SSMS or Azure Data Studio

Commands

1. TODO: NOT WORKING....
2. generate output see

   schemacrawler \
     --server=sqlserver --database=AdventureworksLTS2019 \
       --port=1234 --user=sa --host=host.docker.internal --password="yourStrong(!)Password" \
     --info-level=maximum \
     --command script \
     --script-language python \
     --script ./share/mermaid.py > ./share/output_mssql.md

3. other commands
   • schemacrawler -h

   • schemacrawler \
       --server=sqlserver --database=AdventureworksLTS2019 \
       --user=sa --host=host.docker.internal,1234 --password="yourStrong(!)Password" \
       --info-level=maximum --command=schema > ./share/raw_mssql.txt

   • schemacrawler \
       --server=sqlserver --database="AdventureworksLTS2019" \
       --user=sa --host="host.docker.internal,1234" --password="yourStrong(!)Password" \
       --info-level=maximum execute --command list