CODEWITHSUNDEEP
.netasp.netsql-server
Jason Irwin
Jason Irwin

Reputation: 2045

aspnet_regsql - Creating the Application Services Database for mysql or postgresql database

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?

Upvotes: 0

Views: 920

Answers (1)

dariom
dariom

Reputation: 4578

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.

Upvotes: 1

Related Questions