Re: Migration Documents: Beta 2 to ASP.NET 2.0 Shipping Bits

re:
> you suggested reapplying the aspnetsql scripts on my SQLServer 2000 database to
> reinstall Membership

Actually, I suggested :

"recompile the app in RTM/Release and create a
new Membership database with aspnet_regsql.exe."

You need to recompile the app because the schema for the ASP.NET
Personalization database changed between Beta 2 and RTM,
and running aspnet_regsql will run the *modified* sql scripts
which address the schema changes for the membership db.

re:
> I have yet to find any documents that explain how

See that same document, page 31 :

The section titled : ASP.NET Personalization Database Schema

Description
The ASP.NET personalization database schema has changed since
the Beta 2 release. Any data stored while running an ASP.NET Web
application using the Beta 2 release will fail to load in the RTM release.

Modification Needed
If you use SQL Server, use the following command from the command prompt:

aspnet_regsql ?A all ?D aspnetdb ?E ?S <sqlserver name>

If you use Microsoft SQL Server Express Edition, follow these steps:

1. Attach the database.
2. Run Aspnet_regsql.exe.
3. Detach the database.




Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
ASPNETFAQ.COM : http://www.aspnetfaq.com/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"clintonG" <csgallagher@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23xKmjK65FHA.3976@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks Juan, all other searchs launched the file directly from the search result.
>
> It was your advice Juan that sent me looking for this and other up-to-date
> documentation.
>
> That said, I'm still trying to resolve my broken Beta 2 application that used
> Membership. If you would recall you confirmed Membership changed after Beta 2 and is
> different in 2.0 RTM but I have yet to find any documents that explain how. Furthermore,
> I'm stalled in 'wait a minute' mode because you suggested reapplying the aspnetsql
> scripts on my SQLServer 2000 database to reinstall Membership. If Membership has changed
> after Beta 2 how could running the 'old' sql scripts resolve this issue?
>
>
> <%= Clinton Gallagher
>
>
> "Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> wrote in message
> news:%23umECK45FHA.2600@xxxxxxxxxxxxxxxxxxxxxxx
>> The complete document Clinton points to is available at :
>>
>> http://download.microsoft.com/download/e/3/8/e38818ae-31e5-462b-b9ad-e6d3cd6ad7c1/Breaking%20Changes%20Beta2%20to%20RTM.doc
>>
>>
>>
>>
>> Juan T. Llibre, ASP.NET MVP
>> ASP.NET FAQ : http://asp.net.do/faq/
>> ASPNETFAQ.COM : http://www.aspnetfaq.com/
>> Foros de ASP.NET en Español : http://asp.net.do/foros/
>> ======================================
>> "clintonG" <csgallagher@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:Ovt1vhy5FHA.3416@xxxxxxxxxxxxxxxxxxxxxxx
>>> Thanks Bruce. I also just found this "Visual Studio and .NET 2.0 Breaking Changes from
>>> Beta 2 to RTM" [1] which is quite extensive.
>>>
>>> <%= Clinton Gallagher
>>> METROmilwaukee (sm) "A Regional Information Service"
>>> NET csgallagher AT metromilwaukee.com
>>> URL http://metromilwaukee.com/
>>> URL http://clintongallagher.metromilwaukee.com/
>>>
>>> [1] http://www.theserverside.net/news/thread.tss?thread_id=37383
>>
>>
>>
>>
>>> "Bruce Barker" <brubar_nospamplease_@xxxxxxxxxx> wrote in message
>>> news:%23mMWxTx5FHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
>>>> see
>>>>
>>>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/conversionissuesasp_net.asp
>>>>
>>>> -- bruce (sqlwork.com)
>>>>
>>>>
>>>> "clintonG" <csgallagher@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>>> news:%23QKSAJx5FHA.3432@xxxxxxxxxxxxxxxxxxxxxxx
>>>>> Membership is broken and who knows what else. Does anybody have any referrals to
>>>>> current documents that explain what was changed and how one might respond?
>>>>>
>>>>>
>>>>> <%= Clinton Gallagher
>>>>> METROmilwaukee (sm) "A Regional Information Service"
>>>>> NET csgallagher AT metromilwaukee.com
>>>>> URL http://metromilwaukee.com/
>>>>> URL http://clintongallagher.metromilwaukee.com/
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Migration Documents: Beta 2 to ASP.NET 2.0 Shipping Bits
    ... > SQL2000 and should just learn SQL2005 and now regret not starting when it was in beta. ... I have resisted using SQL 2005 because I'm quite happy with SQL 2000, ... >> Personalization database changed between Beta 2 and RTM, ... >> which address the schema changes for the membership db. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Migration Documents: Beta 2 to ASP.NET 2.0 Shipping Bits
    ... Thanks Juan, I went over the document closely this time and ran ... > new Membership database with aspnet_regsql.exe." ... > Personalization database changed between Beta 2 and RTM, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Replacing VS .NETs SQL Server Express Edition Integration
    ... As you said you already have an existing database that contains the ... membership structure, ... Replacing VS .NET's SQL Server Express Edition Integration ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Seen the Survey?
    ... paper appointment records and census returns for leaders ... I'm looking at it in many ways from someone that knows such a database ... Membership Database that I perceive no real use for nor need for. ... The task is to work with kids and get them active, ...
    (uk.rec.scouting)
  • Re: Need to load 200 users into Form security DB
    ... membership provider" if you want to see what that entails. ... My situation is that I had a development database with some users/roles ... security database in SQL2008 with 11 tables, ...
    (microsoft.public.dotnet.framework.aspnet)
Loading