1
Vote

hangs idefinitely on 'sorting objects by dependency...'

description

was trying to export FROM sql azure (Sitefinity community edition database) to SQL Server 2005 (on domain.com)

comments

hurricanepkt wrote Jan 31, 2011 at 6:57 PM

personally I have seen It take upwards of 10 minutes to process in this step

ghuey wrote Feb 7, 2011 at 5:42 PM

Hi, I am trying to figure this out and I was wondering if when you connected to SQL Azure if you connected to the master database (listed all databases) or select "Specify Database". I have found that if I specify a database, that performance goes down hill pretty fast (and I don't know why since the only difference is that a specific database was set in SMO and the rest of the code is 100% the same). Anyway, did you select "Specify Database" or stick with the default list all databases?

Thanks,
George