SqlCompare stucks at 'Populate ObjectText'

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

SqlCompare stucks at 'Populate ObjectText'

Postby SeriousM » Tue Feb 26, 2013 5:55 pm

Hi,

when i compare a sql 2008 r2 database with a windows azure database the comparer stucks at \"Reading object context\".
WHen i look into the log where is the step \"Populate ObjectText\" where it hangs.

I used the version: 10.2.6.114 because it can handle the renaming operations in azure better.

Here is a screenshot:
http://pbrd.co/V5wQz7

And here the log:
Code: Select all
17:38:28.819|Info   |Logging             |1  |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error
17:38:37.389|Info   |SQL Compare Engine  |9  |Register live database start: Innov8.temp.innov8.head.3b9f7a94a5ebdd6a1442bae899c1f44aaaa56d16
17:38:37.431|Info   |SQL Compare Engine  |9  |Populate Live Start, popoptions: DatabaseCollation, DecryptPost2kEncryptedObjects
17:38:37.431|Info   |SQL Compare Engine  |9  |Populate Live Start, options: ForceColumnOrder, IgnoreFillFactor, IgnorePermissions, IgnoreWhiteSpace, CaseSensitiveObjectDefinition, IgnoreFullTextIndexing, IgnoreComments, IgnoreFileGroups, DoNotOutputCommentHeader, IgnoreUsers, IgnoreUserProperties, IgnoreWithElementOrder, IgnoreDatabaseAndServerName, DecryptPost2kEncryptedObjects
17:38:37.463|Info   |SQL Compare Engine  |9  |Populate major version: SqlServer2008
17:38:37.466|Info   |SQL Compare Engine  |9  |Populate got casing: True
17:38:37.466|Info   |SQL Compare Engine  |9  |Populate Case Sensitive: True
17:38:37.470|Info   |SQL Compare Engine  |9  |Populate FulltextCatalogs start.
17:38:37.473|Info   |SQL Compare Engine  |9  |Populate Fulltext Stoplists start.
17:38:37.475|Info   |SQL Compare Engine  |9  |Populate Fulltext Stopwords start.
17:38:37.477|Info   |SQL Compare Engine  |9  |Populate ObjectNames start.
17:38:37.496|Info   |SQL Compare Engine  |9  |Populate Users start.
17:38:37.505|Info   |SQL Compare Engine  |9  |Populate Tables start.
17:38:37.527|Info   |SQL Compare Engine  |9  |Populate Functions start.
17:38:37.531|Info   |SQL Compare Engine  |9  |Populate Defaults start.
17:38:37.533|Info   |SQL Compare Engine  |9  |Populate Rules start.
17:38:37.535|Info   |SQL Compare Engine  |9  |Populate UDTs start.
17:38:37.538|Info   |SQL Compare Engine  |9  |Populate Table UDTs start.
17:38:37.540|Info   |SQL Compare Engine  |9  |Populate Views start.
17:38:37.546|Info   |SQL Compare Engine  |9  |Populate View Cols start.
17:38:37.552|Info   |SQL Compare Engine  |9  |Populate Procs start.
17:38:37.556|Info   |SQL Compare Engine  |9  |Populate ObjectText start.
17:38:37.613|Info   |SQL Compare Engine  |9  |Populate 2k8 Dependencies start.
17:38:37.620|Info   |SQL Compare Engine  |9  |Populate Table Cols start.
17:38:37.651|Info   |SQL Compare Engine  |9  |Populate Indexes start.
17:38:37.703|Info   |SQL Compare Engine  |9  |Populate Statistics start.
17:38:37.707|Info   |SQL Compare Engine  |9  |Populate ForeignKeys start.
17:38:37.720|Info   |SQL Compare Engine  |9  |Populate Constraints start.
17:38:37.723|Info   |SQL Compare Engine  |9  |Populate Triggers start.
17:38:37.729|Info   |SQL Compare Engine  |9  |Populate UDT Deps start.
17:38:37.732|Info   |SQL Compare Engine  |9  |Populate Roles start.
17:38:37.735|Info   |SQL Compare Engine  |9  |Populate Role Membership start.
17:38:37.738|Info   |SQL Compare Engine  |9  |Populate Schemas start.
17:38:37.741|Info   |SQL Compare Engine  |9  |Populate Assembly Files start.
17:38:37.743|Info   |SQL Compare Engine  |9  |Populate Synonyms start.
17:38:37.745|Info   |SQL Compare Engine  |9  |Populate MessageTypes start.
17:38:37.753|Info   |SQL Compare Engine  |9  |Populate Contracts start.
17:38:37.756|Info   |SQL Compare Engine  |9  |Populate Messages start.
17:38:37.759|Info   |SQL Compare Engine  |9  |Populate Queues start.
17:38:37.764|Info   |SQL Compare Engine  |9  |Populate Services start.
17:38:37.768|Info   |SQL Compare Engine  |9  |Populate Service Bindings start.
17:38:37.770|Info   |SQL Compare Engine  |9  |Populate Contracts start.
17:38:37.772|Info   |SQL Compare Engine  |9  |Populate Routes start.
17:38:37.776|Info   |SQL Compare Engine  |9  |Populate Parameters start.
17:38:37.780|Info   |SQL Compare Engine  |9  |Populate Event Notifications start.
17:38:37.783|Info   |SQL Compare Engine  |9  |Populate DDL Triggers start.
17:38:37.787|Info   |SQL Compare Engine  |9  |Populate XML Schema Collections start.
17:38:37.790|Info   |SQL Compare Engine  |9  |Populate Certs start.
17:38:37.792|Info   |SQL Compare Engine  |9  |Populate SKeys start.
17:38:37.794|Info   |SQL Compare Engine  |9  |Populate AKeys start.
17:38:37.796|Info   |SQL Compare Engine  |9  |Populate Extended Properties start.
17:38:38.122|Info   |SQL Compare Engine  |9  |Populate Permissions  start.
17:38:38.635|Info   |SQL Compare Engine  |9  |Populate DB Settings start.
17:38:38.639|Info   |SQL Compare Engine  |9  |Populate Clean Dangling Objects.
17:38:38.642|Info   |SQL Compare Engine  |9  |Populate Cleanse Dependencies.
17:38:38.648|Info   |SQL Compare Engine  |9  |Register live database finished: Innov8.temp.innov8.head.3b9f7a94a5ebdd6a1442bae899c1f44aaaa56d16
17:38:38.683|Info   |SQL Compare Engine  |9  |Register live database start: innov8.head
17:38:38.687|Info   |SQL Compare Engine  |9  |Populate Live Start, popoptions: DatabaseCollation, DecryptPost2kEncryptedObjects
17:38:38.687|Info   |SQL Compare Engine  |9  |Populate Live Start, options: ForceColumnOrder, IgnoreFillFactor, IgnorePermissions, IgnoreWhiteSpace, CaseSensitiveObjectDefinition, IgnoreFullTextIndexing, IgnoreComments, IgnoreFileGroups, DoNotOutputCommentHeader, IgnoreUsers, IgnoreUserProperties, IgnoreWithElementOrder, IgnoreDatabaseAndServerName, DecryptPost2kEncryptedObjects
17:38:39.045|Warn   |SQL Compare Engine  |9  |Could not run DBCC DBINFO - cannot decrypt text objects.
17:38:39.072|Info   |SQL Compare Engine  |9  |Populate major version: SqlServer2008
17:38:39.100|Info   |SQL Compare Engine  |9  |Populate got casing: True
17:38:39.100|Info   |SQL Compare Engine  |9  |Populate Case Sensitive: True
17:38:39.132|Info   |SQL Compare Engine  |9  |Populate ObjectNames start.
17:38:39.190|Info   |SQL Compare Engine  |9  |Populate Users start.
17:38:39.573|Info   |SQL Compare Engine  |9  |Populate Tables start.
17:38:39.606|Info   |SQL Compare Engine  |9  |Populate Functions start.
17:38:39.637|Info   |SQL Compare Engine  |9  |Populate Defaults start.
17:38:39.665|Info   |SQL Compare Engine  |9  |Populate Rules start.
17:38:39.697|Info   |SQL Compare Engine  |9  |Populate UDTs start.
17:38:39.726|Info   |SQL Compare Engine  |9  |Populate Table UDTs start.
17:38:39.754|Info   |SQL Compare Engine  |9  |Populate Views start.
17:38:39.786|Info   |SQL Compare Engine  |9  |Populate View Cols start.
17:38:39.818|Info   |SQL Compare Engine  |9  |Populate Procs start.
17:38:39.848|Info   |SQL Compare Engine  |9  |Populate ObjectText start.

========== HERE STOPS THE EXECUTION, THE WHEEL JUST KEEPS TURNING ==========


I ask you to help me asap because the current version is not usable and the old one (10.0) is not able to do the things i need.

thank you for your help!
SeriousM
 
Posts: 11
Joined: Mon Sep 27, 2010 9:28 am

Postby Manfred.Castro » Thu Feb 28, 2013 10:33 pm

Your log contains the following entry:

17:38:39.045|Warn |SQL Compare Engine |9 |Could not run DBCC DBINFO - cannot decrypt text objects.

This likely indicates a permissions issue.

Is the account you are using to perform the comparison a member of the sysadmin server role?
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby SeriousM » Fri Mar 01, 2013 1:38 pm

Hi,

it turned out that a reboot was required after the update 10.0 to 10.2.6.114.

Problem solved, thanks!

Cheers
SeriousM
 
Posts: 11
Joined: Mon Sep 27, 2010 9:28 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests