It seems to do what we want as far as backing up a single table, however I tried copying back the data to a small table I set up to test the bcp command on, and it predictably just copies the data.

We know which tables can be synced across environments and which tables have data that should never be synced. The database will be under heavy development for the next 2 years or more.