We are developing an application where we need to move the data from one environment to other through a release management process which involves tracking of data changes, approval by designated people and move the data to the target environment.

We were thinking about to develop a custom solution where we capture all our changes at "Code Level" which requires some extra effort.

Can we use Sql Server 2008 Data change tracking for the required solution? Will that have any performance impact on Sql Server?