Synchronizing schema from local development machine to remote web server

Question

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).

 

Answer 1

hi,

basically you can use SQLCompare on your local machine.. just keep a "copy" of the production db (the one which is live on the real server) on the very same instance you are working locally on, or install another local instance for the task, and proceed with your changes locally to a dev db... when you're done, produce via SQLCompare the "change script", upload it to the production server and execute it locally to it, so you have the job done.. BTW, you can produce the sync script(s) even not having the production db locally but just the DDL sql scripts to generate it, the feature is very handy in RedGate tool..

regards

---

http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools http://www.hotelsole.com/ - http://www.hotelsolericcione.de

Answer 2

Dear Andrea,

Appreciated. I've been in touch with Redgate and they seem to be suggesting a similar approach. Greatly appreciated.

 

Andrew.

---

Andrew Mather