locked
Synchronizing schema from local development machine to remote web server RRS feed

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

     

    Monday, October 18, 2010 10:02 AM

Answers

  • 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
    • Marked as answer by Andrew Mather Tuesday, October 19, 2010 11:08 PM
    Tuesday, October 19, 2010 10:13 PM

All replies

  • 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
    • Marked as answer by Andrew Mather Tuesday, October 19, 2010 11:08 PM
    Tuesday, October 19, 2010 10:13 PM
  • Dear Andrea,

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

     

    Andrew.


    Andrew Mather
    Tuesday, October 19, 2010 11:08 PM