Windows Batch File
Step 1 - Issue port forward command to the Control Panel
START /B kubectl port-forward 5000:5000 > sscp.txt
Step 2 - Create Pod
curl -X "POST" ^
"http://localhost:5000/api/PodAPI/CreatePod?podname=&dbtype=sqlserver&hdsize=10" ^
-H "accept: text/plain"
Step 3- Issue port forwarding to the pod
START /B kubectl port-forward [podname] 8080:80 1433:1433 > podresults.txt
Step 4- Initialize Pod
curl -X "POST" ^
"http://localhost:8080/api/Pod/Init?username=[username]&password=[password]" ^
-H "accept: text/plain"
Step 5- Upload SQL Files to Pod. Below shows you how to add multiple files.
curl -X "POST" "http://localhost:8080/api/SQLFiles/Add?programming_language=tsql" ^
-H "accept: */*" ^
-H "Content-Type: multipart/form-data" ^
-F files="@C:\\your directory\\your sub directory\\file1.tsql" ^
-F files="@C:\\your directory\\your sub directory\\file2.tsql"
Step 6-Add Data Source
curl -X "POST" ^
"http://localhost:8080/api/DataSources/Add" ^
-H "Content-Type: application/json" ^
-d "{ \"database_type\": \"SQLSERVER\", \"source_uid\": \"[username]\", \"source_pwd\": \"[password]\", \"source_database_name\": \"[database name]\", \"source_server\": \"[server address]\", \"source_trusted_connection\": \"false\", \"simulated_uid\": \"[pod user name]\", \"simulated_pwd\": \"[pod password]\", \"simulated_database_name\": \"master\", \"simulated_server\": \"127.0.0.1,1433\", \"simulated_schema_name\": \"\", \"simulated_trusted_connection\": \"false\"}"
Step 7 - Test Data Source(optional)
curl -X "POST" ^
"http://localhost:8080/api/DataSources/TestConnection" ^
-H "accept: text/plain"
Step 8-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"
Last updated