Hi,
I've automated the schema change propagation to the member database using this approach:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-update-sync-schema
The schema changes go through fine.
I've run :
alter table mytable add blah varchar(20)
go
update mytable set blah = 'blah'
go
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?
Thanks.