This destination plugin lets you sync data from a CloudQuery source to a Microsoft SQL Server compatible database. This includes both Microsoft SQL Server and Azure SQL Server.
Loading plugin documentation
We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.
kind: destination
spec:
name: "mssql"
path: "cloudquery/mssql"
registry: "cloudquery"
version: "v5.2.0"
spec:
# Connection string in the format `server=localhost;user id=SA;password=yourStrongP@ssword;port=1433;database=cloudquery;`
connection_string: "${MSSQL_CONNECTION_STRING}"
# Optional parameters:
# auth_mode: ms
# schema: dbo
# batch_size: 1000 # 1K entries
# batch_size_bytes: 5242880 # 5 MiB
# batch_timeout: 20s
batch_size and batch_size_bytes.connection_string (string) (required)"sqlserver://username:password@hostname/instance" basic connection using a named instance"sqlserver://username:password@localhost?database=master&connection+timeout=30" select "master" database and set connection timeout (default instance)auth_mode (string) (optional) (default: ms)azure value.
See SDK documentation for more information.
Supported values:- `ms` _connect to Microsoft SQL Server instance_
- `azure` _connect to Azure SQL Server instance_
schema (string) (optional) (default: dbo)dbo.batch_size (integer) (optional) (default: 1000)batch_size_bytes (integer) (optional) (default: 5242880 (= 5 MiB))batch_timeout (duration) (optional) (default: 20s (= 20 seconds))log option to connection_string.
See SDK documentation for more details.kind: destination
spec:
name: "mssql"
path: "cloudquery/mssql"
registry: "cloudquery"
version: "v5.2.0"
spec:
connection_string: "${MSSQL_CONNECTION_STRING};log=255"
yourStrongP@ssword as a password.docker run \
-e "ACCEPT_EULA=Y" \
-e "MSSQL_SA_PASSWORD=yourStrongP@ssword" \
-p 1433:1433 \
-d \
mcr.microsoft.com/mssql/server:2022-latest
cloudquery for database name in this example.docker exec $(docker ps -alq) \
/opt/mssql-tools/bin/sqlcmd \
-U "SA" \
-P "yourStrongP@ssword" \
-Q "CREATE DATABASE cloudquery;"
docker ps -alq returns container ID for the latest started container.
You can use container ID discovered manually via docker ps output instead.cloudquery Microsoft SQL Server database
via the following connection string:server=localhost;user id=SA;password=yourStrongP@ssword;port=1433;database=cloudquery;
kind: destination
spec:
name: "mssql"
path: "cloudquery/mssql"
registry: "cloudquery"
version: "v5.2.0"
spec:
connection_string: "server=localhost;user id=SA;password=yourStrongP@ssword;port=1433;database=cloudquery;"