Downgrading ASPNETDB from 2005 to 2000

[Cirene]

I created my ASP.NET website with VS 2008. It created the SQL 2005 db for
asp.net membership stuff.

My server only accepts SQL Server 2000 dbs.

Any advice on "downgrading"?

If I just create scripts for the tables, views and stored procs, should I be
all set? Or are there other concerns?

Thanks!

 

[Mark Fitzpatrick]

Yes, the scripts should work fine from what I've seen before. I don't
believe there's anything specific to SQL 2005 in any of the T-SQL statements
so a create script should do just fine for you.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression

 

[Juan T. Llibre]

Everything you need to know about using membership
with SQL Server 2000 is in this article by Scott Guthrie :

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

 

[Cirene]

Thanks everyone! Very helpful.

Everything you need to know about using membership
with SQL Server 2000 is in this article by Scott Guthrie :

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx