今天倒腾Database project的时候,在讲project check in到tfs中时,出现一个“莫名其妙”的error
TF10187:Could not open document XXX.dbmdl
The process cannot access the file becuause it is being used by another process.
google一下,发现dbmdl(db model的缩写),是个临时文件,每次project打开的时候,都会自动生成,每个用户都是唯一的,用于提高部署的性能。
dbmdl file is effectively a temporary copy of the schema model and is created when a project is opened. The file can’t be checked into source control.
When creating a new SQL 2008 Database Project Visual, SVN automatically elects not to check this file in so that also suggests to me that it‘s not a good idea to check it in to source control.
From what I can make out, it is a serialized file of your db model and is used as a cache for improving the performance of deployment. It is unique per user thus should not be checked into source control.
参考文档:
https://social.msdn.microsoft.com/Forums/vstudio/en-US/118eadf7-533b-4992-af60-6a70c158f0f5/sqlproj-and-dbmdl?forum=visualstudiogeneral
http://stackoverflow.com/questions/3634649/what-is-the-function-of-the-dbmdl-file-in-vs-database-project
TF10187:Could not open document XXX.dbmdl
原文:http://www.cnblogs.com/ljhdo/p/5026165.html