开发者

How Do I Attach a SQL Server Express Database to a Visual Studio 2010 project?

How do I do this?

  • Attach an SQL Server Express Database to a Visual Studio project so that...
    • my source control contains the most resent schema for the database including stored proced开发者_开发问答ures (can' t use SQL Compact Ed. because need to be able write stored procedures against the database),
    • can be version controlled using TFS without using tools like Red Gate Source Control,
    • can be automatically set up/updated when a developer gets the latest version of a project (using MS Build or similar build script api),
    • (would be nice) can be published after entire project passes unit tests.

Is any of this possible and if so how do I do it?


Sounds like you want a migration framework, more than you want to store the actual database. Look into migration libraries for .Net like FluentMigrator.


This sounds like continuous Database Integration:

http://www.codeproject.com/KB/architecture/Database_CI.aspx

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜