I want to use the Row-stored table for OLTP,
and to use the Column-stored table for Analyze using Power BI.
So, I hope to sync table between Row-stored and Column-stored.
There are the Row-stored table on Azure SQL Database standard,
and There are the Column-stored table on SQL Server Express.1 vote
In Japanese language portal,
when I try to create a new Sync Group,
I enter NAME, select REGION 'east asia' and then select one subscription from our multiple subscriptions.
However after selecting one subscription,
it causes the region reset to US north.
I hope the region remains my selection.1 vote
This request will be under review.
Presently there is option to change the subscription of azure SQL server but there is no such option to change\move the DataSync to other subscription.1 vote
Thanks for your suggestion! You are right. Will see how many customers need this. — Linda Wang
Currently the only way to backup a database that contains sync groups is to either deprovision the sync groups, or make a copy of the database, deprovision the sync groups in the copy, and backup the copy. This adds unnecessary time and inconvenience to backup process for any database that contains sync groups.1 vote
I have a few tables that use date and datetime as part of the primary key, and would like to be able to synchronise these tables which is currently unsupported.1 vote
Provide some sort of warning in the Azure Portal regarding the schema modification that occurs during SQL Data Sync
I would like more transparency in to what occurs during the SQL Data Sync when creating it in the Azure portal.
I created a Sync group, tried running it, the sync failed, and left the Hub database throwing SQL errors in my web app. Thus, there should be some sort of notification that the Hub database is modified when running the Sync.1 vote
- Don't see your idea?