0

I know that it is possible (and straightforward) to create an application services database using a SQL Server database. However, I would like to use another database technology such as MySQL or PostgreSQL for my authentication/role management. I was wondering if there is a similar command to do so for non-mssql databases or if there is a commonly used workaround for doing so?

Improve this question

1 Answer 1

Reset to default
1

The aspnet_regsql program can only create database objects for membership and role management for Microsoft SQL Server databases.

That said it is possible to create your own structures for other database tables and implement your own membership and role provider types (or use someone else's implementations).

For MySQL the Connector/Net looks like the best way to go. A search leads to a blog post about how to use and configure it. Alternatively you could implement your own, but I would recommend going with the Connector/Net.

I don't have any experience with PostgreSQL but I'd be surprised if there wasn't an existing provider out there. Again, you could implement your own if needed.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

For PostgreSQL, one can find an open source provider here: dev.nauck-it.de/projects/aspsqlprovider . On the site, look under Wiki -> Installation for more information on how to set it up.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.