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
精彩评论