Support for MS Sqlserver

[RobertLD]

Our company is actively pursuing stricter guarantees on cross-team data via the data contract-cli. We currently make use of MS SqlServer and would like to know if this is supported within the data contract cli?

[jochenchrist]

Currently, it is not implemented, but should not be too difficult to implement, as soda-core supports ms sqlserver.

As a precondition, we'd need to add sqlserver to the server specification
https://github.com/datacontract/datacontract-specification/?tab=readme-ov-file#server-object

[jochenchrist]

Would you (or your team) have some capacity to contribute a Pull-Request?

[RobertLD]

I'm sure I can find some time to pull the code and investigate, hopefully sometime this week or next.

[jochenchrist]

Added sqlserver to data contract specification: https://github.com/datacontract/datacontract-specification/?tab=readme-ov-file#sql-server-server-object

[RobertLD]

Added sqlserver to data contract specification: https://github.com/datacontract/datacontract-specification/?tab=readme-ov-file#sql-server-server-object

Including the supporting code, or just preparing the doc?

I've cloned the repo last night and was beginning to poke around

[simonharrer]

Jochen added the server type to the specification.

What is now missing is adding support in the CLI within the python code base. Do you want to have a try for this @RobertLD ? It should be straight forward mapping to soda sqlserver type.

[RobertLD]

I'll take a crack at it once I get my bearings

[RobertLD]

Added sqlserver to data contract specification: https://github.com/datacontract/datacontract-specification/?tab=readme-ov-file#sql-server-server-object

Jochen added the server type to the specification.

What is now missing is adding support in the CLI within the python code base. Do you want to have a try for this @RobertLD ? It should be straight forward mapping to soda sqlserver type.

I've published a rough PR for the changes because the specification published earlier for SQLServer doesn't match exactly what I would expect (namely missing the driver, etc.)

With some guidance or an update of the spec I can continue work on it
#204

ty

[RobertLD]

Completed in PR #204