Home Dashboard Directory Help
Search

SSDT Project - Validating the Project Model takes >10 minutes for large DBs by ObsidianPhoenix


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


2
0
Sign in
to vote
Type: Bug
ID: 788553
Opened: 5/24/2013 1:18:29 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

When using SSDT to manage a large database project (~5000 objects), attempting to build or publish the Database results in Visual Studio taking >10 minutes to validate the project model.

Smaller DBs seem to validate in well under a minute. However this long period of validation renders the DB project virtually unuseable for large scale DB management.
Details
Sign in to post a comment.
Posted by Microsoft on 8/13/2013 at 5:37 PM
Thank you for the feedback. We have made some performance enhancements that may have helped. We have seen databases much larger than this build under 5 minutes. However, results may vary drastically, depending on the complexity of your schema. Try downloading our latest release from http://msdn.microsoft.com/en-us/data/hh297027 to see if the performance improves.

Thanks,

Martin
Sign in to post a workaround.