Bit late but i havent explored this topic much since i posted.
I am still a bit unsure about this.
Atm i have setup a few flows in power automate that fetch all data from sql, creates or updates it in dataverse. this sync is run every day.
I could use virtual tables
But id like to get answers to these questions first:
1. Is it a two way sync - if value is updated in virtual table in dataverse will it update in sql and vice versa?
2. If i create more columns in the virtual table, will those sync to sql table?
3. If a new column is created in sql table, will that be synced automatically to dataverse virtual table?
4. If a row is deleted in either sql table or dataverse table, will that sync both ways?
Another option i think can use is Dataflows
But how does dataflows compare to virtual tables and having flows running?
