Automate migration scripts

jofanon

What's the best way to retrieve a set of migration scripts (stored in version control using SQL Source Control) and then execute them?

Is there a method somewhere to say retrieve a reference to a set of scripts?

I don't want to write code that....

Connect to TFS
Get latest scripts
Identify uncommitted scripts
Executes the scripts

There must be a way of doing this through the API?

Brian Donahue

I'm sorry to say there is no function in the SQL Comparison SDK to interface with source control.