As a single developer in a small business I'm developing a data-driven website on my local machine using VS2008 Professional (I also have 2010 Professional)
It is then synchronised with a dedicated server using Expression Web (ditto design)
I'm using SqlExpress both machines and as features are added, I want to synchronize the dedicated server schema from the local schema
VS2010 has such a feature, but it's a ____ of a price to pay for one feature - basically adding fields as I add functionality.
I'm surprised SqlServer doesn't have such a feature built in - am I missing something?
(I've trialled RedGate SqlCompare, but it can't access the remote db, and I'm reluctant to enable SqlServer Remote Connections on a machine I don't own).
View Complete Post