Our application uses the .net 2.0 membership provider and we are attempting to switch off of Microsoft and onto MySql. I have downloaded the free 30 day trial of dotConnect for MySQL and have run the InstallWebTables.sql file found in dotConnect/MySQL/Web/ASP.NET 2. What I find is that the aspnet_roles table differs significantly from what we find on our MSSQL boxes.
The MSSQL side has the following schema:
Code: Select all
CREATE TABLE [dbo].[aspnet_Roles](
[ApplicationId] [uniqueidentifier] NOT NULL,
[RoleId] [uniqueidentifier] NOT NULL DEFAULT (newid()),
[RoleName] [nvarchar](256) NOT NULL,
[LoweredRoleName] [nvarchar](256) NOT NULL,
[Description] [nvarchar](256) NULL)
Code: Select all
CREATE TABLE aspnet_roles (
applicationname VARCHAR(255) NOT NULL,
roleid VARCHAR(40) NOT NULL,
rolename VARCHAR(245) NOT NULL,
CONSTRAINT aspnet_roles_roleid_pk PRIMARY KEY (roleid),
CONSTRAINT aspnet_roles_rolename_key UNIQUE (rolename, applicationname)
)
Why are these two tables so different and how should we go about converting the data from MSSQL to MySql in this case?
Thanks