### Start SQL Server Docker Container and Initialize Schema Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Quickly starts a SQL Server instance using Docker Compose. After starting, manually execute the schema initialization script. Ensure you are in the 'sql/tools' directory. ```Bash docker compose up -d sqlserver docker compose exec sqlserver bash /tmp/create_schema.sh ``` -------------------------------- ### Start KingbaseES Docker Container and Initialize Schema Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Quickly starts a KingbaseES database instance using Docker Compose. After starting, manually execute the schema initialization script. Ensure you are in the 'sql/tools' directory. ```Bash docker compose up -d kingbase docker compose exec kingbase bash -c 'ksql -U $DB_USER -d test -f /tmp/schema.sql' ``` -------------------------------- ### Start MySQL Docker Container Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Quickly starts a MySQL database instance using Docker Compose. Ensure you are in the 'sql/tools' directory. ```Bash docker compose up -d mysql ``` -------------------------------- ### Start DM Database Docker Container and Initialize Schema Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Quickly starts a DM database instance using Docker Compose. After starting, manually execute the schema initialization script. Ensure you are in the 'sql/tools' directory. ```Bash docker compose up -d dm8 docker compose exec dm8 bash -c '/opt/dmdbms/bin/disql SYSDBA/SYSDBA001 \`/tmp/schema.sql' exit ``` -------------------------------- ### Start PostgreSQL Docker Container Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Quickly starts a PostgreSQL database instance using Docker Compose. Ensure you are in the 'sql/tools' directory. ```Bash docker compose up -d postgres ``` -------------------------------- ### Start OpenGauss Docker Container and Initialize Schema Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Quickly starts an OpenGauss database instance using Docker Compose. After starting, manually execute the schema initialization script. Ensure you are in the 'sql/tools' directory. ```Bash docker compose up -d opengauss docker compose exec opengauss bash -c '/usr/local/opengauss/bin/gsql -U $GS_USERNAME -W $GS_PASSWORD -d postgres -f /tmp/schema.sql' ``` -------------------------------- ### Start Oracle Docker Container (Apple Silicon) Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Quickly starts an Oracle database instance using Docker Compose for MacBook Apple Silicon. Note that ORACLE_SID is 'FREE' for this version. Ensure you are in the 'sql/tools' directory. ```Bash docker compose up -d oracle_m1 ``` -------------------------------- ### Start Oracle Docker Container (x86) Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Quickly starts an Oracle database instance using Docker Compose for x86 architecture. Ensure you are in the 'sql/tools' directory. ```Bash docker compose up -d oracle ``` -------------------------------- ### Install simple-ddl-parser Dependency Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Installs the 'simple-ddl-parser' Python library required for the database conversion script. Use pip3 if pip is not aliased. ```Bash pip install simple-ddl-parser # pip3 install simple-ddl-parser ``` -------------------------------- ### Load KingbaseES Docker Image Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Loads a KingbaseES Docker image from a tar file. Run this command in the directory containing the image tar file. ```Bash docker load -i kdb_x86_64_V009R001C001B0025.tar ``` -------------------------------- ### Load DM Database Docker Image Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Loads a DM database Docker image from a tar file. Run this command in the directory containing the image tar file. ```Bash docker load -i dm8_20240715_x86_rh6_rq_single.tar ``` -------------------------------- ### Convert MySQL to PostgreSQL Script Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Converts a MySQL database script to a PostgreSQL script using the convertor.py script. The output is printed to the console and can be redirected to a file. Ensure you are in the 'sql/tools/' directory. ```Bash python3 convertor.py postgres # python3 convertor.py postgres > tmp.sql ``` -------------------------------- ### Destroy and Recreate PostgreSQL Docker Container and Volume Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md Stops a PostgreSQL Docker container and removes its associated data volume to create a clean database instance. Ensure you are in the 'sql/tools' directory. ```Bash docker compose down postgres docker volume rm ruoyi-vue-pro_postgres ``` === COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.