Is Fabric lakehouse best option for my query?
Dear Skool mates, We have decommissioned CRM and AX databases(Azure VM- On-prem). We need to decommission the VM completely but we need the database accessible and query able. This to save costs. What is the best option to save the SQL tables from CRM and AX? 1. Fabric lakehouse? 2. Export each table in CRM and AX to datalake and then link to synapse workspace, query able through serverless pool? If lakehouse, how do we run backups? If I move from F64 to different capacity does the lakehouse remain same? Why because, we have recently moved the capacity from one region to other but MS said that I need to republish all the PBI reports. This is worrying me. Is sql server, I can take backups and restore at any point. How do I keep the backups or relavent in lakehouse? Moreover, if I export all the tables from CRM and AX, we are going to decommission so the database doesn't exist and cannot rerun lakehouse. Please suggest the best option. Regards Krish