version control static data

[jliu7988]

dear Redgate

i'm evaluating sql source control, our project needs to version control a growing amount of metadata so the version control static data feature is exactly what we need.

the problem :
- checking the database in & linking the static data (SQLServer R2) to TFS2010 .. all good no problems
- insert rows, update data, delete rows ... was expecting "changes to commit" to appear but nothing.
- to get around this i add a column to table and it picks up the schema change right away. i remove the column so the schema stays the same but source control can now pick up the static data change.
- commit to TFS.. now all good.

is this a known issue ? i have search the board but couldn't find much on this subject.

thanks,
D

[Brian Donahue]

I'm sorry you have encountered this issue. I will be responding to you via email with the information relevant to troubleshooting this problem.

Thanks!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521