How can we help you today? How can we help you today?

SQLCMD Go Support

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

butlerpaul
0

Comments

3 comments

Sort by
  • 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
    DanC
    0
  • butlerpaul
    Thanks for your reply Dan, do you know will it be supported in Flyway?
    butlerpaul
    0
  • 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.
    Peter_Laws
    0

Add comment

Please sign in to leave a comment.