I am trying to figure out if FogBugz can accomodate the following situation. I work with a small team of developers on projects where we have to go offline for short periods of time (1-10 days). Teams working on projects are generally 1-5 developers.
It would have to be done on a lower level, at the database level. SQL Server synchronization might work, I'm not sure. Unfortunately I think it would be rather complicated to implement. Try searching for "access synchronization" or "sql server synchronization". Any general tool that lets you merge data from two databases with the same schema would get you started... the only problem is primary and foreign keys...
Michael H. Pryor
Fog Creek Home