SQLCMD Go Support

butlerpaul

Hello,

Do you know if there is / will there will be support for SQLCMD Go when using SCA PowerShell module to deploy a database?

From my understanding, when using SCA PowerShell module to deploy it uses SQLCMD ODBC which has a dependency on ODBC Driver 17, there is currently no support for ODBC Driver 18 in SQLCMD ODBC.

https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16&tabs=odbc%2Cwindows&pivots=cs1-powershell#system-requirements

Microsoft have delivered a completely new sqlcmd implemented in go, and which does not use ODBC, but they have a native driver in go inside of it.

Thanks,

Paul

DanC

Hi @butlerpaul

Unfortunately, we have no current plans to support SQLCMD Go within SQL Change Automation

I would advise posting the idea here: https://redgate.uservoice.com/forums/267000-sql-change-automation

butlerpaul

Thanks for your reply Dan, do you know will it be supported in Flyway?

Peter_Laws

Hello,

Because Flyway doesn't depend on ODBC and rather uses Microsoft's JDBC interface, so it has no implicit dependency on SQLCMD unlike Change Automation.

If you particularly wish to use SQLCMD Go, flyway does support Script Migrations so you could call and execute SQLCMD Go from flyway, though I cannot think of any SQLCMD Go functionality that isn't already available from SQL.