I have a development environment and a production (LIVE) environment.

In most cases I want to copy data from Prod to Dev in order to simulate the clients setup (for bughunting and late stage development). But some tables that I use for general setup I want to only move from Dev to Prod. E.g., I have a list of financial accounts, I want to be able to assign a colour to an account. I create a static table for this purpose, I then add 'Green' and 'Red'. Currently I would need two different files, one for comparing the 'accounts' table, and one for comparing the 'colours' table.

What I would like is on the colours table in Data Compare to be able to switch direction. I would make a Data Compare file called 'Prod->Dev', which generally copies to Dev. Then in the settings I would set the 'colours' table to compare Dev->Prod, so only this/these tables are synchronized in the opposite direction from the main setup.

When my clients later add a new account in Prod, it should be copied to Dev, but thay however cannot add new colours, I do that in Dev, so when I add 'Yellow' and I then run my entire Data Compare file 'Prod->Dev', it should not be deleted in Dev, but rather get copied to Prod.