views:

66

answers:

3

You see it a lot in examples and I've done itt on some small projects, but for a larger project with multiple developers, does it really work well to put the database file (.mdf) in the project?

What is your "workflow" like with your database? Do you put the file in your project and check it in like everything else, or do you have a central database up and running that you all use, or what?

Made this community wiki since it doesn't really have a single answer.

+5  A: 

Use the GDR R2 Database Project. Each developer makes changes to a local copy of DB and syncs version controlled changes to it. Incremental changes can be applied to production using the output artifacts of the GDR R2 database project.

Mitch Wheat
+1  A: 

Most of the time projects i've worked on have a database server with a production database and a few beta/dev databases, the development is done using the beta/dev databases.

A change to the connection string is all that's needed to switch between db's.

John Boker
How are your schema changes tracked?
Chuck Conway
The project i work on right now we are using Linq2Sql, our database access is done through a dbml, which is in source control.
John Boker
A: 

This related question may help.

CesarGon