StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POVSTS database schema comparison not saving comments
text
Body
copied!<p>We use VSTS 2008 with SP1 and GDR R2 installed.</p> <p>Found the next problem: </p> <ol> <li>2 identical databases (for example Database1 and Database2);</li> <li>Database1 is a working database, Database2 is a production one;</li> <li>adding a new stored procedure to the Database1 with comments (description, author etc. before the <code>CREATE PROCEDURE</code> statement);</li> <li>trying to compare schemes on Database1 (source) and Database2 (target); the new SP successfully added to the Database2 but without comment above the <code>CREATE PROCEDURE</code> statement (but comments in the SP body are fully preserved).</li> </ol> <p>The part of the stored procedure in Database1:</p> <pre> -- ============================================= -- 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 </pre> <p>The result in Database2 after schema comparison:</p> <pre> 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 </pre> <p>It murdered comments. The check mark in the <code>Schema compare options... -> Ignore Comments</code> is unchecked. </p> <p>Is there any way to make this work?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload