How prevent the script date line from makig GIT flag every file as changed with SQL Server scripted objects -
i'm using git archive sql server database design using tasks --> generate scripts option sql server management studio context menu of database object.
using generate scripts file each object in database results in comment line being added @ top of each file timestamp showing when script generated.
/****** object: trigger [mytrigger] script date: 07/07/2015 11:58:15 ******/ when export whole database git folder see what's changed, line makes git think every single file has changed, i'm not interested in change. current work-around bulk find/replace in notepad++ , and convert timestamp numbers zero.
the regex search string is:
script date\: \d+\/\d+\/\d+ \d+\:\d+\:\d+ i replace numbers zeros:
script date: 00/00/0000 00:00:00 however... seems unnecessary step. there better way?
you can turn off option completely:

click on advanced button, , set include descriptive headers option false:

Comments
Post a Comment