View Revisions: Issue #6676

Back to Issue
Summary 0006676: Preserve comments on stored procedures when loading DDL changes (new parameter dataloader.sql.event.strip.comments)
Revision 2024-12-12 15:07 by cquamme
Additional Information
Revision 2024-12-12 17:27 by pbelov
Additional Information It would be best to preserve existing behavior and add a new parameter to replicate comments along with T-SQL code - when customer requests it.
It is likely that in the past comments had caused problems with replications (on some DB platforms) and were removed as a remedy.
Revision 2024-12-12 19:00 by cquamme
Additional Information
Revision 2024-12-12 15:07 by cquamme
Description When you sync a stored procedure with comments in SQL Server that contains comments, the comments do not get synced. We would like to change this so comments get synced as well.
Revision 2024-12-19 16:08 by pbelov
Description When you sync a stored procedure with comments that contains comments, the comments do not get synced.
We would like to change this so comments get synced as well, when a new parameter dataloader.sql.event.strip.comments is set to false
To maintain backwards compatibility this parameter will default to true.
Revision 2024-12-12 15:07 by cquamme
Steps To Reproduce
Revision 2024-12-19 16:08 by pbelov
Steps To Reproduce -- Procedure - for MS SQL Server syntax:
CREATE OR ALTER PROCEDURE dbo.test_comments
 @Rounds INT
AS
BEGIN
    -- This rocedure fills existing table random_load_test2 with random values
    DECLARE @completedRounds INT = 0
    /*
     * DONE!
     * populate_random_load_test2 555
     */
  SET @completedRounds = @completedRounds + 1
END;