Backup Database and push to TFS server

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?

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.