Analyzing database schema takes hours

Using a new SQL2005 database project in VS2010. I did import objects and settings, and built the project. It seems to be stuck at 'Analyzing database schema. Your database projects will be ready after 3267 operations are completed'.

This seems to take hours. Is there any way to speed this up?

I read somewhere that this may happen if my .dbmdl file is too big, but it's just 2.6MB.

What are the 3 types of database schema?

Schema is of three types: Logical Schema, Physical Schema and view Schema.

What is a schema query?

In a SQL database, a schema is a list of logical structures of data. A database user owns the schema, which has the same name as the database manager. As of SQL Server 2005, a schema is an individual entity (container of objects) distinct from the user who constructs the object.

Go to Project Settings
click on the Database Settings button
Under the Operational tab

3.1 uncheck Auto create statictics and

3.2 Uncheck Auto update statistics checkbox.

This will reduce your numbers of operations by about 90% and the analysis should finish instantly.