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

Question

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 procedures (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?

Out of interest, what's the objection to Red Gate tools? – David Atkinson Sep 29 '11 at 20:49 — David Atkinson, Sep 29 '11 at 20:49

score 0 · Accepted Answer · answered Sep 29 '11 at 18:33

0

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

answered Sep 29 '11 at 18:33

Khalid Abuhakmeh

10,709
10
52
75

Very interesting, I've never heard of this. I think this could work for my situation. Thanks for the tip! – Sep 29 '11 at 18:40
I currently have used FluentMigrator on several projects and it works great. – Khalid Abuhakmeh Sep 29 '11 at 18:55

score 0 · Answer 2 · answered Sep 29 '11 at 18:38

0

This sounds like continuous Database Integration:

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

answered Sep 29 '11 at 18:38

Decker97

1,643
10
11

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

2 Answers2