.NET Core version?

[philipmat]

.NET Core version?

[ErikEJ]

I do now, makes a lot of sense.

[ErikEJ]

I have a feeling that it might be possible to simply create a .NET 6 Console app, include the relevant files and just build it.

Then set up a pipeline to build a .NET global tool.

[ErikEJ]

Design proposal: Port of export2sqlce.exe to a .NET 6/8 global tool

• Tool name: ErikEJ.ExportMssql2Sqlite (command name: exportmssql2sqlite
• Only support sqlite export
• Create github pipeline to build and test (using free SQL Azure?)
• Create readme.md
• Publish to NuGet

[ErikEJ]

Are you referring to the export2sqlce command line tool? Or something else?

[philipmat]

At a minimum it would be the scripting libraries - the Sql*Scripting.dll files.
The command line tools would be great as well, since they're the most likely candidate to be executed on another platform

[ErikEJ]

@philipmat Assume you are aware that only SQlite is cross platform (not SQL Server Compact) ?

[philipmat]

Yes, I'm mostly interested in the SQL Server-to-SQLite conversion and that I can make it work on Linux.

To be fair SQL CE/Compact was EOL in 2021, so maybe it would be unrealistic to expect it to work with modern .NET (Core).

The SQL Server component though, can move forward and it would be a great boon for those like myself who would want to extricate their larger MSSQL DB into a more manageable SQLite DB for integration tests and the like.

If that's outside the scope of this project, I fully understand.

[ErikEJ]

No, I think the most valuable part would be a .NET CLI to extract/port a SQL Server db to SQLite

[philipmat]

I'd be happy to pitch in and help, whether to start this process (I'll need some guidance on where to start and what parts need updating) or with ancillary work: testing, maybe setting up a CI pipeline to help validate the conversion?

[ErikEJ]

This is actually blocked for now, as System.Data.Sqlite does not run on Linux

[alexey-leonovich]

This is actually blocked for now, as System.Data.Sqlite does not run on Linux

What do you mean by that? My sample .NET 8.0 console application referencing latest System.Data.Sqlite 1.0.118 runs without any problem on WSL2 (Ubuntu 22.04.3 LTS).

[ErikEJ]

@alexey-leonovich Wow - did not realize that. Thanks - are you also interested in the SQL Server => sqlite migration feature?

[alexey-leonovich]

Thanks - are you also interested in the SQL Server => sqlite migration feature?

Almost not interested (I'm a Windows user :)). Just accidentally came here .. and created a test application)