.NET Core version?

Question

.NET Core version?

Closed this issue 6 months ago · 15 comments

Are there any plans of moving to .NET Core, in particular for the command line tools?

I'd like to do some prototyping and incorporate this into our CI pipeline (Linux-based) and all our workflow has been .NET Core based for several versions now.

I know we could install Mono in a container and use it that way, but it feels it would be easier to contribute as well if the core library was Core- or Standard-based.

Answer 1 · 2023-09-25T14:40:51.000Z

I do now, makes a lot of sense.

Answer 2 · 2023-09-27T12:45:52.000Z

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

Answer 3 · 2023-09-27T14:09:37.000Z

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

Answer 4 · 2023-10-01T07:57:49.000Z

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

Answer 5 · 2023-10-01T15:15:28.000Z

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.

Answer 6 · 2023-10-01T17:26:03.000Z

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

Answer 7 · 2023-10-01T17:38:23.000Z

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?

Answer 8 · 2023-10-01T18:33:59.000Z

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.

Answer 9 · 2023-10-02T08:07:23.000Z

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

Answer 10 · 2023-12-29T12:50:34.000Z

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

Answer 11 · 2024-04-04T12:17:15.000Z

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).

Answer 12 · 2024-04-04T12:27:09.000Z

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

Answer 13 · 2024-04-04T12:38:22.000Z

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)

Answer 14 · 2024-10-13T07:08:48.000Z

@ErikEJ could you please elaborate why this is not planned? Not enough time or there are technical difficulties?

Answer 15 · 2024-10-13T07:11:29.000Z

Not high priority, and only a single upvote, and too little value, and not something I feel like supporting.