Skip to content

SQL Server database setting ignored #724

@Arthurm1

Description

@Arthurm1

Sling version:

1.5.13

What is the Operating System?

Linux

Do you have a CLI Pro/Platform subscription?

No

Description of the issue

Setting the SQL Server connection using the following works fine...
sling conns set MSSQL type=sqlserver host=<host> user=<user> database=<database> password=<password> port=<port>

But using the URL style connection results in the database setting being ignored and so the sql server user's default db is used and, if different, the table to export is not found...
sling conns set MSSQL url="sqlserver://myuser:mypass@host.ip:1433?database=mydatabase"

Replication Configuration

./sling run --src-conn MSSQL --src-stream 'dbo.myTable' --tgt-object 'file:///tmp/foo.parquet'

Log Output

2026-04-02 15:38:44 INF Sling CLI | https://slingdata.io
2026-04-02 15:38:44 DBG opened "file" connection (conn-file-Dny)
2026-04-02 15:38:44 DBG Sling version: 1.5.13 (linux amd64)
2026-04-02 15:38:44 DBG type is db-file
2026-04-02 15:38:44 DBG using: {"columns":null,"mode":"full-refresh","select":null,"transforms":null}
2026-04-02 15:38:44 DBG using source options: {"empty_as_null":false,"datetime_format":"AUTO","max_decimals":-1}
2026-04-02 15:38:44 DBG using target options: {"header":true,"compression":"auto","concurrency":7,"datetime_format":"auto","delimiter":",","file_max_rows":0,"file_max_bytes":0,"max_decimals":-1,"use_bulk":true,"add_new_columns":true,"column_casing":"normalize"}
2026-04-02 15:38:44 INF connecting to source database (sqlserver)
2026-04-02 15:38:44 DBG opened "sqlserver" connection (conn-sqlserver-mssql-bK0)
2026-04-02 15:38:44 INF reading from source database
2026-04-02 15:38:44 DBG closed "sqlserver" connection (conn-sqlserver-mssql-bK0)
2026-04-02 15:38:44 INF execution failed

fatal:
--- task_run.go:127 func2 ---
~ failure running task (see docs @ https://docs.slingdata.io/sling-cli)
--- task_run.go:402 runDbToFile ---
--- task_run_read.go:41 ReadFromDB ---
--- database.go:1652 GetSQLColumns ---
~ Could not ReadFromDB
--- database.go:1808 GetColumns ---
~ Could not get source columns
--- database_sqlserver.go:533 GetTableColumns ---
did not find table or synonym: "dbo"."myTable"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions