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