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:

enter image description here

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

enter image description here


Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -

How to provide Authorization & Authentication using Asp.net, C#? -