SQL Simulator - Docker
  • Welcome
  • Getting Started
    • About SQL Simulator(beta) - Docker
    • Features
    • Benefits
    • Pricing
    • Supported Databases
    • Technical Overview
      • PostView Merge
        • Step 1
        • Step 2
        • Step 3
        • Step 4
        • Step 5
      • PreView Merge
        • Step 1
        • Step 2
        • Step 3
        • Step 4
      • Dry Run
        • Step 1
        • Step 2
        • Step 3
        • Step 4
        • Step 5
        • Step 6
    • Self Destruct Events
    • Docker Install Guide
      • SQL Server
      • Oracle
      • MySQL
      • Postgres
    • Limitations
    • Schedule Free Onboarding
  • Web UI Tutorials
    • SQL Server
      • Initialize Container
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • Oracle
      • Initialize Container
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • MySQL
      • Initialize Container
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • Postgres
      • Initialize Container
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
  • API Tutorials
    • Introduction
    • SQL Server
      • Windows Batch File
    • Oracle
      • Windows Batch File
    • MySQL
      • Windows Batch File
    • Postgres
      • Windows Batch File
  • Help
Powered by GitBook
On this page
  1. API Tutorials
  2. MySQL

Windows Batch File

Step 1- Initialize Container

curl -X "POST" ^
  "http://localhost:8080/api/Pod/Init?username=[username]&password=[password]" ^
  -H "accept:  text/plain" 

Step 2- Upload SQL Files to Pod. Below shows you how to add multiple files.

curl -X  "POST" "http://localhost:8080/api/SQLFiles/Add?programming_langague=mysql" ^
  -H "accept: */*" ^
  -H "Content-Type: multipart/form-data" ^
  -F files="@C:\\your directory\\your sub directory\\file1.mysql" ^
  -F files="@C:\\your directory\\your sub directory\\file2.mysql" 

Step 3-Add Data Source

curl -X "POST" ^
  "http://localhost:8080/api/DataSources/Add" ^
  -H "Content-Type: application/json" ^
  -d "{\"database_type\": \"MYSQL\",  \"source_uid\": \"[source db username]\",  \"source_pwd\": \"[source db password]\",  \"source_database_name\": \"[source db name]\",  \"source_server\": \"[server address]\",  \"source_port\": \"3306\",  \"simulated_uid\": \"[pod db username]\",  \"simulated_pwd\": \"[pod db password]\",    \"simulated_database_name\": \"sys\",  \"simulated_server\": \"mysql\",    \"simulated_port\": \"3306\"}"

Step 4 - Test Data Source(optional)

curl -X "POST" ^
  "http://localhost:8080/api/DataSources/TestConnection" ^
  -H "accept:  text/plain" 

Step 5-Perform Preview Merge. You also have the option of doing a DryRun or PostviewMerge.

curl -X "GET" ^
  "http://localhost:8080/api/Run/PreviewMerge" ^
  -H "accept:  text/plain" 
PreviousMySQLNextPostgres

Last updated 6 months ago