skoruba / IdentityServer4.Admin

The administration for the IdentityServer4 and Asp.Net Core Identity
MIT License
3.57k stars 1.15k forks source link

Using multiple data providers for different datastores #670

Open jovball opened 4 years ago

jovball commented 4 years ago

I have a business need to separate the IdentityDb datastore onto an Oracle database while the other data stored (Configuration, PersistedGrants, Admin) will be on SQL Server.

I have already created a working project with all of the data stores on Oracle (spoiler alert: future pull request coming later this summer). Can I separate the datastores onto different providers without doing major customization?

jovball commented 4 years ago

I've answered this question myself in the best way. I have a working branch that is using Oracle for IdentityDb and SQL Server for the rest. I also have a working branch that is using Oracle for everything. Those will be future pull requests but I'd like to do those after this project is on IdentityServer4 v4.

skoruba commented 4 years ago

This is interesting idea, I will think about it, it should be absolutely possible to extent current setup around db providers.