SQL Server 2005 - Syncing development/production databases

Posted by hamlin11 on Stack Overflow See other posts from Stack Overflow or by hamlin11
Published on 2009-07-06T07:19:07Z Indexed on 2010/03/08 5:36 UTC
Read the original article Hit count: 1035

I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server.

My main concern is deploying schema + data updates to developer machines from the "master" development copy.

Is there some built-in functionality or tools for publishing schema + data in such a fashion? I'd like it to take as little time as possible. Can it be done from within SSMS?

Thanks in advance for your time

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server