Sql Azure geo-replication not replicating schema changes

1
votes

I have created two blank sql azure database instances in 2 different regions and enabled geo-replication between them. I can failover between them no problem. I create the tables in the primary. I am expecting to see the schema changes replicated to the secondary, but this does not happen. Why not?

UPDATE:

SELECT * FROM sys.geo_replication_links

executed on primary master shows me the partner server and database

SELECT * FROM sys.dm_geo_replication_link_status

executed on primary master is empty

1
azure-sql-database

1 Answers

3
votes

It absolutely should happen. Any structural changes should be transmitted through Geo-Replication. The same as with data. If you're not seeing this, you may not have set up the geo-replication properly. Validate this is working by looking at sys.geo_replication_links. You can also look at sys.dm_geo_replication_link_status to see if something has gone wrong. If everything is actually connected correctly and you're still not seeing the table changes replicated, you should contact support.