Export of Dynamics NAV-data to Dataverse with minimum performance affect on a +340gb SQL-database

[Anonymous]

Hi!

The increase of reporting accuracy and close to real-time analysis lead to new demands. Our current setup with is basically a replica of Dynamics NAV2017 SQL (onprem) which runs 1/night + plus some integrations to supporting programs databases via scripts. The database is restored every night, which takes approx 40 minutes, during that time no access is possible. The built in to in SQL doesn´t work for us. We like Powerplatform and look forward to more frequent data updates without affecting performance in NAV.

What would your setup be?

Cheers/BruceMountain