Change Application ID

.NET
1

I have duplicated my site (specifically the Club Starter Kit) so I can run the same site on my local computer and make changes as needed for my new client. I would like to change the application ID of the copied site so the two versions do not collide with each other. Is this necessary and if so, how do I accomplish this?

I’ve tried to update the application id of the copy in the “aspnet_Applications” table and I’m getting the following error:

The data in row 1 was not committed.
Error Source: .Net SqlClient Data Provider
Error Message: The UPDATE statement conflicted with the REFERNCE constraint “FK_aspnet_Me_Appli_145c0a3f”. The conflict occured in databse "c:…VCHSG.mdf, table “dbo.aspnet_Membership”, column ‘ApplicationId’.

Thanks for any help!

2

Change it in the configuration files. Or use a different database by setting the connecitonstringnames to something different in the configuration files. In any case, you should not be touching those parts of the database.

3

I think that you will need to make a new record in the applications table. Then you will need to UPDATE all ApplicationID fileds in the other tables. Then delete the original record.

You can try deleting the original record periodically to uncover any tables that you have not yet changes. ie… it won’t let you delete if there will be any orphans.

good luck… let me know how it goes