Plan not attached. -- saw it now.

The main performance improvement on this type of process is using the hash compare as you do.

Following are possibilities -...

then as per the error the file can't be opened - pretty clear - and just proves that you didn't really search for anything - just expect that we do...

not enough really - just on the forums here you get 99 hits
and please post the full error message, not just a screen print that does not show the...

have you even bothered googling for it? first hit I get has the reason for the issue and the solution.

also take in consideration that having compression turned on (page or row, or even columnstore) will change the space requirements. many times significantly, specially with columnstore.

Add to this that Installing Excel on a Server is not supported by Microsoft and you would also have issues with licensing in that anyone accessing that server would require...

i do not think there is any other option than a third party tool for that.
see https://dbmstools.com/version-control-tools/sqlserver for some options for SSMS.

Most of the times and if...

Looks like you are not after possible tools, but for someone to do the work for you (so you can charge your client as if it was done by yourself).

would help if you posted what you have researched already and what issues you found with each of the possible tools to do each part of the job.

so...

not to let down the work you have done but have you considered using a tool like http://record-editor.sourceforge.net/ which has most likely a significant part of the functionality you are...

thing with these "schema changes" is that many times they do not affect the code - one possible way to avoid this error in some cases is to set "