TFS中SQL表数据的版本控制 [英] Versioning of SQL Table Data in TFS
问题描述
我们公司有一个非常重要的SQL存储过程，它可以半定期对我们的一个生产数据库中的数据进行大量更改。到目前为止，这个过程一直在SQL事务中执行，它允许
用于"回滚"。发生任何错误时所有未提交的更改。
Our company has a very important SQL stored procedure which makes a significant number of changes to the data in one of our production databases on a semi-regular basis. Until now, this procedure has been executing from within a SQL Transaction, which allows for "rolling back" all uncommitted changes if any error occurs.
由于最近对脚本工作流程进行了一些修改，它将不再可能在事务内部执行，导致我们失去ROLLBACK功能。但是这个功能是必不可少的，因为错误发生了，当它们
时，必须恢复所有更改。
Due to some recent modifications to the workflow of the script, it will no longer be possible for it to execute inside of a transaction, causing us to lose the ROLLBACK functionality. But this functionality is essential, as errors DO occur, and when they do, all changes must be reverted.
我们很好奇是否有任何使用Team Foundation Server的方法将每个SQL事务管理为"更改集"并且在我们在脚本处理期间捕获错误的情况下以编程方式恢复到先前的更改集。
We are curious if there is any way of using Team Foundation Server to manage each SQL transaction as a "change set" and having it programmatically revert to the previous change set in the event that we capture an error during script processing.
提前感谢。
推荐答案
Kevin.M.Stoffel，
Hi Kevin.M.Stoffel,
感谢您在此发帖。
每次签入更改时，它们都会作为更改集存储在服务器上。变更集包含版本控制中每个项目的历史记录。当然，您可以回滚到您想要的任何变更集，请参阅以下链接：
Each time you check in changes, they are stored on the server as a changeset. Changesets contain the history of each item in version control. Of course, you could roll back to any changeset you want, please refer to the following link:
https://www.visualstudio.com/en-us/docs/tfvc/roll-back-changesets
I我不熟悉SQL事务，如果源控件中的文件发生了这种变化，那么TFS可以将更改记录为变更集 检查更改后。如果误解了您的意思，请更详细地描述您的问题。
I am not familiar with the SQL transaction, if this change happen to the file in source control, then TFS could record the change as changeset after you check in the changes. If is misunderstand your meaning, please describe your problem in more detail.
最好的问候
Limitxiao高
Limitxiao Gao
这篇关于TFS中SQL表数据的版本控制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
