Oracle support

[jamiedeignan2]

Any thoughts on how difficult it might be to extend or fork this code to use Oracle as a back-end database instead of SQL?

In my (very brief) skimming through the database related code it looks like the chunk necessary for building the database just uses Microsoft's "MigrationBuilder" framework which I believe is database agnostic with the proper db provider on the other end. To your knowledge is the code dependent on any SQL Server specific feature or behaviors?

[louisaxel-ambroise]

Hi @jamiedeignan2

The repository uses EF Core with the Code First approach. Currently in the main branch the database has some SQL server specific migrations and model configuration.

I'm currently working on making the project working with several databases by removing the SQL server features from the shared project. However there are some triggers and views that needs to be manually scripted, so a little customisation will be required for each provider.

The current goal is to make the project compatible with SQL server, SQLite and PstGreSQL. I don't have access to an Oracle database, and I don't know how to create the triggers/views for it so it's not included in the current plan.

There is an EF Core provider for Oracle, so once the PR will be completed you should be able to integrate it without much work/changes. I'll be glad to help you, and I'll really appreciate if you could contribute with this integration in the repo with a PR!

Thanks

[jamiedeignan2]

Interesting. I will pass this info on to the rest of my team. I don't personally have the necessary development experience to integrate Oracle but our team might elect to take on that work down the line. Thanks!

[louisaxel-ambroise]

Hi @jamiedeignan2 The latest version v2.3.0 includes the support for multiple database providers.

As I said in a previous comment I don't have access to an Oracle database right now, so it's not currently supported. If you want to contribute to this repo and add this provider it'd be really appreciated! I'd also be glad to help you if you need help.

Regards,
Louis-Axel