I ran SQL Data Compare using my development database root folder from TFS that was created by SSC when I linked the database to source control as the source scripts folder and I used my staging branch root folder prior to merging from the development branch as the target scripts folder and SDC picked up the differences in the lookup table data. However, when I went to use the SDC synchronization wizard to generate the deployment script, I got an error saying that the "given key was not present in the dictionary". However, if I right-click on just the lookup table object in the comparison pane and select the "Show Object Synchronization Script", I get the script with no errors. If I can use this method to compare dev branch to staging branch as script folders I can probably automate some kind of short term work around to my problem, as long as the synchronization wizard doesn't error out. Otherwise I'm really going to have problems dealing with any static data changes to the database. It will be a maintenance nightmare. As another potential worka round, I tried using migration scripts to manually change the data myself, but I got a message saying that since there were no schema changes involved I couldn't even use a migration script. Please help me figure this out. This is a critical issue for us.