I have a cross-subscription/cross-tenant Active Geo Replication setup. Company A (geo-primary) is replicating to secondary database (geo-secondary) in Company B. In Company B is required to create some views and store procedures on geo-secondary, but because this database is read only, the idea is to replicate and sync to a new write-enabled database.
What alternatives are available besides Data Factory to accomplish this replication/sync?
@GeethaThatipatri-MSFT thanks for your answer. Before definitively deciding to use Data Factory I want to explore other options and I would prefer something that is part of Azure SQL Database technology. I think Data Sync is a great option but already tested this and is not possible because it needs to create some objects and my geo-secondary database is read only.
Now I'm considering a different approach, maybe having a new database in same server and give it permissions to read the geo-secondary, this will allow me to create views, procedures, etc. but reading data from the replica.