VSTS Database Schema Comparison Does Not Save Comments

Question

We use VSTS 2008 with installed SP1 and GDR R2.

Found the following problem:

• 2 identical databases (e.g. Database1 and Database2);
• Database1 is a working database; Database2 is a production database;
• adding a new stored procedure to Database1 with comments (description, author, etc. before the operator CREATE PROCEDURE);
• trying to compare schemas on Database1 (source) and Database2 (Target); the new SP was successfully added to the database2, but without comments above the statement CREATE PROCEDURE(but the comments in the SP body are completely saved).

Part of the stored procedure in Database1:

- ==============================================
- Author: [author here]
- Create date: [creation date here]
- Description: [description here]
- ==============================================
CREATE PROCEDURE [schema here]. [Procedure name here] 
    @ param1 uniqueidentifier,
    @ param2 nvarchar (64),
    @ param3 bit,
    @ param4 int = 1,
    @ param5 int = 25,
    @ param6 int = 0 output,
    @ param7 int = 0 output
As

Result in Database2 after schema comparison:

CREATE PROCEDURE [schema here]. [Procedure name here]
@ param1 UNIQUEIDENTIFIER, @ param2 NVARCHAR (64), @ param3 BIT, @ param4 INT = 1, @ param5 INT = 25, @ param6 INT = 0 OUTPUT, @ param7 INT = 0 OUTPUT
As

He killed the comments. The checkbox is Schema compare options... -> Ignore Commentsnot set.

Is there any way to make this work?

Answer 1

, - , Gert Drapers, aka The Datadude, . , , . , GDR2, , , .