This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
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?
@Jorge Villacorta Welcome to Microsoft Q&A thanks for posting your question
Based on the scenario either Data sync or Azure data factory is a viable option. Any specific reason why you dont want to go with data factory?
Regards
Geetha
@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.