Using mssql database on linux

Turns out it is possible to use ms-sqlserver under linux

https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16&tabs=ubuntu2004

controlling the beast ….

systemctl status mssql-server
systemctl stop mssql-server
systemctl disable mssql-server
systemctl enable mssql-server

A nice GUI would be cool!!

https://dbeaver.io sudo add-apt-repository ppa:serge-rider/dbeaver-ce sudo apt-get update sudo apt-get install dbeaver-ce

And now .. a way to get Volvo vida files accessible under linux. This allows for exporting data and having access to stored procedures. (the tools on windows seemed rather limiting…)

/opt/mssql-tools/bin/sqlcmd -S . -U sa -P GunnarS3g3 -Q "CREATE DATABASE BaseData_Data ON (FILENAME = '/var/opt/mssql/data/BaseData_Data.MDF'),(FILENAME = '/var/opt/mssql/data/BaseData_Data_log.ldf' ) FOR ATTACH_REBUILD_LOG"

/opt/mssql-tools/bin/sqlcmd -S . -U sa -P GunnarS3g3 -Q "CREATE DATABASE CARCOM ON (FILENAME = '/twee/volvo/CarComRT_Data.MDF'),(FILENAME = '/twee/volvo/CarcomRT_Log.LDF' ) FOR ATTACH_REBUILD_LOG"

/opt/mssql-tools/bin/sqlcmd -S . -U sa -P GunnarS3g3 -Q "CREATE DATABASE DIAGSWDLREPOSITORY ON (FILENAME = '/twee/volvo/DiagSwdlRepository_Data.MDF'),(FILENAME = '/twee/volvo/DiagSwdlRepository_log.LDF ' ) FOR ATTACH"

/opt/mssql-tools/bin/sqlcmd -S . -U sa -P GunnarS3g3 -Q "CREATE DATABASE DIAGSWDLSESSION ON (FILENAME = '/twee/volvo/DiagSwdlSession_Data.MDF'),(FILENAME = '/twee/volvo/DiagSwdlSession_log.LDF' ) FOR ATTACH"

In Dbeaver the stored procedure can be executed, by right clicking. It then opens a new windows, where you can add the parameter.

To execute a stored procedure in SQL Server that requires a parameter, you can use the EXEC statement followed by the name of the stored procedure and provide the parameter value within parentheses. Here’s how you can pass a parameter to the stored procedure [dbo].[vadis_GetEcuVariantData]:

USE [CARCOM]
DECLARE @return_value int
DECLARE @parameter_name int = 821
EXEC @return_value = [dbo].[vadis_GetEcuVariantData]@parameter_name

SELECT       'Return Value' = @return_value

it return DiagNumber : 30728270 AA

DiagNumber	EcuTypeI	EcuI	Add	Ecu	Nam	CfgId	Gwy	ProtocolId
30728270 AA	372,302	CEM	52	821	CEM	611		7