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.
Schema is of three types: Logical Schema, Physical Schema and view Schema.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With