Pay attention to file length in database project after a synchronization
One of the coolest feature of Database Projects in VS2008 is the ability to synchronize the database project with a physical instance of SQL server.
This is useful if not all people from the team have the ability to run a database project (this is solved in vs2010 where database project are available even in the professional edition), or if some DBA makes modification to a database with management studio.
After a full synchronization occurs double check the file structure, because the synchronization procedure store size of the files into the definition
the SIZE parameter is really huge, and this can slow down deploy process during unit testing. Keep this in mind and always take a look to the file definition after you sync a database project with a live database.
You can always avoiding to update file definition (because they rarely change) to avoid this problem
Tags: Database Project