I've automated the schema change propagation to the member database using this approach:
The schema changes go through fine.
I've run :
alter table mytable add blah varchar(20)
update mytable set blah = 'blah'
I could see the column 'blah' on the member database, but the update did not go through.
I went into the sync setup and ticked that new column for the sync, still nothing happened.
What am I doing wrong?