By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,969 Members | 1,564 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,969 IT Pros & Developers. It's quick & easy.

importing asp.net membership tables

P: n/a
JJ
How can I import my current asp.net membership records in my local sql
server to the empty tables on the live server?

I've tried removing contraints with:

ALTER TABLE aspnet_Applications NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Membership NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Paths NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationAllUsers NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationPerUser NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Profile NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Roles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_SchemaVersions NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Users NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_UsersInRoles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_WebEvent_Events NOCHECK CONSTRAINT ALL

Then importing and selecting 'Enable identity insert' on each table, but I
still get errors relating to conflicting Keys.

I assume either I need to temporarily remove some other constraints or
import in a certain order (if so which order?)

Thanks in advance,

JJ
May 30 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
KJ
Try using the Database Publishing Wizard:

http://www.microsoft.com/downloads/d...displaylang=en

It *should* generate the T-SQL script you need.

"JJ" <ab*@xyz.comwrote in message
news:uh****************@TK2MSFTNGP03.phx.gbl...
How can I import my current asp.net membership records in my local sql
server to the empty tables on the live server?

I've tried removing contraints with:

ALTER TABLE aspnet_Applications NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Membership NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Paths NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationAllUsers NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationPerUser NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Profile NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Roles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_SchemaVersions NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Users NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_UsersInRoles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_WebEvent_Events NOCHECK CONSTRAINT ALL

Then importing and selecting 'Enable identity insert' on each table, but I
still get errors relating to conflicting Keys.

I assume either I need to temporarily remove some other constraints or
import in a certain order (if so which order?)

Thanks in advance,

JJ

May 30 '07 #2

P: n/a
JJ
thanks - I'm trying that. I keep getting this error when trying run the
publish script on my shared hosts' sql server:

I've have set my database to use SQL_Latin1_General_CP1_CI_AS as instructed
by my hoster, but why then am I getting these errors???
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 45
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 52
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 76
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 83
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 90
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 50
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 58
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 84
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 92
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnet_UsersInRoles_AddUsersToRoles', because it
does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnet_UsersInRoles_RemoveUsersFromRoles', because
it does not exist or you do not have permission

"KJ" <n_**********@Mail.comwrote in message
news:OZ*************@TK2MSFTNGP06.phx.gbl...
Try using the Database Publishing Wizard:

http://www.microsoft.com/downloads/d...displaylang=en

It *should* generate the T-SQL script you need.

"JJ" <ab*@xyz.comwrote in message
news:uh****************@TK2MSFTNGP03.phx.gbl...
>How can I import my current asp.net membership records in my local sql
server to the empty tables on the live server?

I've tried removing contraints with:

ALTER TABLE aspnet_Applications NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Membership NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Paths NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationAllUsers NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationPerUser NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Profile NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Roles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_SchemaVersions NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Users NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_UsersInRoles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_WebEvent_Events NOCHECK CONSTRAINT ALL

Then importing and selecting 'Enable identity insert' on each table, but
I still get errors relating to conflicting Keys.

I assume either I need to temporarily remove some other constraints or
import in a certain order (if so which order?)

Thanks in advance,

JJ


May 30 '07 #3

P: n/a
KJ
Check this out:

http://community.sgdotnet.org/blogs/.../17/49593.aspx

"JJ" <ab*@xyz.comwrote in message
news:uI**************@TK2MSFTNGP03.phx.gbl...
thanks - I'm trying that. I keep getting this error when trying run the
publish script on my shared hosts' sql server:

I've have set my database to use SQL_Latin1_General_CP1_CI_AS as
instructed by my hoster, but why then am I getting these errors???
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 45
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 52
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 76
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 83
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles,
Line 90
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 50
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 58
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 84
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 92
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnet_UsersInRoles_AddUsersToRoles', because it
does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnet_UsersInRoles_RemoveUsersFromRoles', because
it does not exist or you do not have permission

"KJ" <n_**********@Mail.comwrote in message
news:OZ*************@TK2MSFTNGP06.phx.gbl...
>Try using the Database Publishing Wizard:

http://www.microsoft.com/downloads/d...displaylang=en

It *should* generate the T-SQL script you need.

"JJ" <ab*@xyz.comwrote in message
news:uh****************@TK2MSFTNGP03.phx.gbl...
>>How can I import my current asp.net membership records in my local sql
server to the empty tables on the live server?

I've tried removing contraints with:

ALTER TABLE aspnet_Applications NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Membership NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Paths NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationAllUsers NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationPerUser NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Profile NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Roles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_SchemaVersions NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Users NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_UsersInRoles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_WebEvent_Events NOCHECK CONSTRAINT ALL

Then importing and selecting 'Enable identity insert' on each table, but
I still get errors relating to conflicting Keys.

I assume either I need to temporarily remove some other constraints or
import in a certain order (if so which order?)

Thanks in advance,

JJ



May 30 '07 #4

P: n/a
JJ
Thanks. I'd got around the problem somehow, but that page explains exactly
what was happening and how I _should_ have solved it.

JJ

"KJ" <n_**********@Mail.comwrote in message
news:ui**************@TK2MSFTNGP04.phx.gbl...
Check this out:

http://community.sgdotnet.org/blogs/.../17/49593.aspx

"JJ" <ab*@xyz.comwrote in message
news:uI**************@TK2MSFTNGP03.phx.gbl...
>thanks - I'm trying that. I keep getting this error when trying run the
publish script on my shared hosts' sql server:

I've have set my database to use SQL_Latin1_General_CP1_CI_AS as
instructed by my hoster, but why then am I getting these errors???
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_AddUsersToRoles, Line 45
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_AddUsersToRoles, Line 52
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_AddUsersToRoles, Line 76
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_AddUsersToRoles, Line 83
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_AddUsersToRoles, Line 90
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 50
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 58
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 84
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure
aspnet_UsersInRoles_RemoveUsersFromRoles, Line 92
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnet_UsersInRoles_AddUsersToRoles', because it
does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'aspnet_UsersInRoles_RemoveUsersFromRoles',
because it does not exist or you do not have permission

"KJ" <n_**********@Mail.comwrote in message
news:OZ*************@TK2MSFTNGP06.phx.gbl...
>>Try using the Database Publishing Wizard:

http://www.microsoft.com/downloads/d...displaylang=en

It *should* generate the T-SQL script you need.

"JJ" <ab*@xyz.comwrote in message
news:uh****************@TK2MSFTNGP03.phx.gbl.. .
How can I import my current asp.net membership records in my local sql
server to the empty tables on the live server?

I've tried removing contraints with:

ALTER TABLE aspnet_Applications NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Membership NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Paths NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationAllUsers NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_PersonalizationPerUser NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Profile NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Roles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_SchemaVersions NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_Users NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_UsersInRoles NOCHECK CONSTRAINT ALL
ALTER TABLE aspnet_WebEvent_Events NOCHECK CONSTRAINT ALL

Then importing and selecting 'Enable identity insert' on each table,
but I still get errors relating to conflicting Keys.

I assume either I need to temporarily remove some other constraints or
import in a certain order (if so which order?)

Thanks in advance,

JJ



May 30 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.