Thank you so much - exactly what I was looking for - was right there the whole time and didn't see it. Thank you.

You could do a scheduled backup, but that will be on a whole database and might be overkill.

on separate networks (no direct connection between them) and for only 10000 rows,...

The problem here is going to be the fact that you do not have a primary key, or a column that can uniquely identify a row, so doing a diff...

Enviroment Variables have a bunch of uses some of the most common one are the location of a file to import as this usually differs from Dev / test and...

I have a similar situation, I have a currently SQL 2008R2 db running on ent, (no using any of the ent features) and I want to move that db to...