I ave an application that has a configuration database (menu items, settings, etc.)
In my development machine my database has a differente schema from the QA (and production) database.
The MyTable in QA is the MyTable view on my machine that joins data from MyTableQA (replica of QA's MyTable) and MyTableLocal (local overrides).
This way, I can keep all APIs (SPs, services, etc.) in sync with QA.
Everytime I need to use my local database, I only have to sync with QA, which SQL Data Compares does nicelly.