Is that a way that i can schedule to run a SQL agent job to generate the database schema and data script file and then check in to the Team Foundation Server?
A:
You got it backwards. You push the database generation script into source control, and generate the database from the source script. If you find yourself trying to do the reverse, you're doing it wrong.
Remus Rusanu
2010-07-21 05:13:22
@Remus: not necessarily. If you're working from a legacy database, that can be impractical. Trust me, I've learned that lesson the hard way.
Robaticus
2010-07-21 12:48:26