SQL Compare Error using sp_addrolemember

BaPoll01

Hi,
We use SQL Compare 9. We are synchronizing from DB-Snapshot scripts to Database in local instance SQL Server Version 2008.

Using the scripts we get errors like the example below when SP addrolemember tries to add an item x (a role or a user) to a role, but x does not yet exist since it is created later in the script.

Procedure sp_addrolemember,
User or role 'aspnet_Membership_FullAccess' does not exist in this database.

Is there a way to influence the order in which objects are defined taking into consideration the dependencies between objects ? We have searched this forum and google without success. Thx for any help.

peter.peart

Thanks for your post.

There isn't any way at all to say "create this object before that" I'm afraid, although the SQL Compare dependency engine should be handling it correctly. If it's not, it's a bug.

Have you tried this with V10? If the same thing happens, we'd need copies of your schemas to reproduce and assuming we could reproduce it, we can schedule a bug fix for a later release of the tool.

Pete