Rohan Thomas

Migrate from Beta to Visual Studio 2005 RTM in a jiffy

Refering to my previous post here, I received some comments on what exactly to do when "nothing seems to work"....

Here is what to do :

You need to get the aspnet_regsql running and remove the aspnet tables from your database. (To run this just go to the C:\WINNT\Microsoft.NET\Framework\v2.0.50727> dir (or whatever version of beta you have, and type aspnet_regsql. Follow the wizard are select the table to remove the aspnet tables from)

For this you need to make sure that the aspnet tables are empty. You can use this script to get all the data cleared : (WARNING!!!! -> all your aspnet data will be lost i.e Users, roles, etc)

truncate table aspnet_Membership
truncate table aspnet_PersonalizationAllUsers
truncate table aspnet_PersonalizationPerUser
truncate table aspnet_Profile
truncate table aspnet_SchemaVersions
truncate table aspnet_WebEvent_Events
truncate table aspnet_UsersInRoles
truncate table aspnet_Applications
truncate table aspnet_Paths
truncate table aspnet_Roles
truncate table aspnet_Users

For some cases, the last 4 tables wont let you truncate, in this case go to those 4 tables and delete off the foreign keys and try truncating again.

After you have removed the data and used aspnet_regsql to remove the aspnet tables from your db, get a backup of this db and move it to a server which has RTM version installed on it and again run the aspnet_regsql but this time choose the new db over which you restored your backup and create aspnet tables.

Change the connection string of your app and try running it on the new db

Thats it! You're done....

Thank you for your mails, I will try my best to answer them and assist you, so don't hesitate to drop me a line...

Cheers!