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



Thanks Juan, I went over the document closely this time and ran
aspnet_regsql and my application is becoming more stable. At least it loads
now.

Note the document has an error. The -D flag is not supported. No big deal
but note it should be -d.

On retrospect, other than using Enterprise Manager I have no real need to
continue using SQL2000 and should just learn SQL2005 and now regret not
starting when it was in beta.

<%= Clinton Gallagher



"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> wrote in message
news:uqoU6K95FHA.2264@xxxxxxxxxxxxxxxxxxxxxxx
> 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
    ... > you suggested reapplying the aspnetsql scripts on my SQLServer 2000 database to ... new Membership database with aspnet_regsql.exe." ... Personalization database changed between Beta 2 and RTM, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP.NET 2.0
    ... Juan, it seems a bit cavalier for you to claim that this beta software won't ... screw up his VS.NET 2003 installation. ... That's exactly what happened with one of the beta builds I installed. ... >> Karl thx for the prompt reply. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: WS2003 SP1 RC1 0x800B0003
    ... And users should be willing to read the caveats MS posts in many, ... > If RC1 was buggy, and that reflects on not being ... Oh, come on Juan. ... This is strictly a Beta ...
    (microsoft.public.windowsupdate)
  • Re: Is there any freeware DB product compatible with Ms Access?
    ... Juan I. Cahis wrote: ... Are you sure that it has something similar to Access (Database)? ... Según su página, son compatibles. ...
    (microsoft.public.windowsxp.general)