There doesn't seem to be an MS SQL Server target. ...
# troubleshootingf
florian
10/05/2022, 1:07 PMThere doesn't seem to be an MS SQL Server target. How do you load data into MSSQL with Meltano?
v
visch
10/05/2022, 2:39 PMI wrote one, but it's not a great target as it doesn't support incremental data loads and some other good features. https://github.com/AutoIDM/autoidm-target-mssql
visch
10/05/2022, 2:40 PMI've been using it in production for over a year now though 🤷
h
Henning Holgersen
10/11/2022, 8:01 AMHmmm… perhaps we should talk @visch. A new creation of mine, oblivious to your work: https://github.com/radbrt/target-mssql - I’m about to start looking at incremental loads.
p
pat_nadolny
11/18/2022, 6:58 PM@florian target-mssql is now added to MeltanoHub and can be added via the CLI https://hub.meltano.com/loaders/target-mssql. I would note that this is the variant that @Henning Holgersen is working on so it technically still in development but I'm sure feedback is welcome if you wanted to start testing/using it
h
Henning Holgersen
11/18/2022, 7:09 PMPublishing this now would not have been possible without stealing @visch’s test suite from the Postgres target. Now, we are reasonably able to enumerate what works and what doesn’t. PRs are of course welcome.
v
visch
11/18/2022, 7:14 PMawesome glad it helped, great work Henning! I"ll have to mess with it myself 😄