Migrating ASP.NET Membership Database to SQL Azure

ghost

New Member
I am trying to migrate a database from SQL Server 2008 to SQL Azure. The database that I am attempting to migrate includes the ASP.NET Membership database (http://www.asp.net/web-forms/tutorials/moving-to-aspnet-20/membership). This database works fine when I run it in my SQL Server 2008 database. However, when I try to authenticate a user against SQL Azure, I receive an error that says:"Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again."However, I'm not sure what to do. When I try to update the index on the aspnet_Applications table, I receive a foreign key problem. I am using the following in an attempt to migrate my non-clustered index to a clustered index:\[code\]ALTER TABLE aspnet_ApplicationsDROP CONSTRAINT PK__aspnet_A__SOMEIDALTER TABLE aspnet_ApplicationsADD CONSTRAINT PK__aspnet_A__SOMEID PRIMARY KEY CLUSTERED(ApplicationId)\[/code\]Can someone please help me overcome this issue? Thank you!
 
Back
Top