Hi,
I think many of us are looking at this.
For some people, the replicated data in the Synapse Workspace is good enough.
It is a "Serverless SQL Pool" , which you can query like a SQL instance.
The structure of the data in those tables look more or less identical to the tables you currently get from DES.
It all depends on how you are using the data for your other application.
The Synapse Serverless Pool isn't that quick. It is absolutely fine if you are just going to be running reports against the data. A few extra seconds will be ok.
If you are going to be hitting the data a lot, it just won't be responsive enough.
At this point, you'll probably have to look at a Synapse Pipeline (Azure Data Factory) job to push the data from Synapse to your SQL database.
So, you can build a pipeline job to ship the data out to Azure SQL from Synapse/Azure Data Lake.
So, unfortunately it is not as simple as DES was to use.
I personally wouldn't have minded if they had just said "we want to charge for DES".
It would have been less painful than all this.
I have been on this thread too. Where others have also used pipelines to get the data out to Azure SQL.
community.dynamics.com/.../data-export-services-des---deprecation---metadata-information
Regards,
Shaun
