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

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

Good catch! Thanks...

re:
> 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.

I'm getting to the same reasoning, too, with a slight difference.

I have resisted using SQL 2005 because I'm quite happy with SQL 2000,
and I was caught totally unaware by breaks like the SDK's Quickstart
*requiring* SSE. I've also got a 1.1 app which I, absolutely, don't want
to move over to 2.0 ( it's got thousands an thousands of lines and works fine ).

I'l be setting up SQL 2005 in a second box
and play with it and ASP.NET 2.0 there.

My main server will keep on working with
ASP.NET 1.1 and ASP.NET 2.0 + SQL 2000 for a while.

But, the wheels of progress can't stop...so SQL 2005 is in my futire.




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:elyz5g95FHA.2552@xxxxxxxxxxxxxxxxxxxxxxx
> 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: 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: 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: syncing a PocketPC with an odbc datasource
    ... Actually we are in Beta for our new product coming soon. ... You're able to map the field from Appointments, Contacts, Tasks and any SQL ... CE database to any ADO updateable Table/View. ... > which uses proprietary databases on the handheld. ...
    (microsoft.public.pocketpc.developer)
  • 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: How can i deploy a database with Membership Tables?
    ... If the server is yours then yes, ... Membership can be used with SQL2000 ... when deploying your data and database to the remote ... You'll also want to determine if your hosting service supports the SQL ...
    (microsoft.public.dotnet.framework.aspnet)