I am using SQL Server 2008 R2. We have two database, one is development and another one is for testing. We want to maintain both databases in sync but only in structure and stored procedures, not in data. Both databases contain different data but structure should remain the same. Is there any way to achieve this?
closed as off topic by Mark Storey-Smith, Phil, RolandoMySQLDBA, dezso, Leigh Riffel Jan 28 at 13:37
Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.