Hey everyone!
I used to have a Business Central SaaS environment but no longer want to pay for a license. I exported the database via a .bacpac file and restored it to Azure SQL so I can still access historical data.
Question: What’s the best way to view and query all that data (especially PDF attachments) directly in SQL?
- Context: I’ve located some of my PDF references in
[Tenant Media] (and possibly [Document Attachment]), but simply writing the BLOB to a .pdf file doesn’t always yield a valid PDF (there may be headers or compression).
- Goal: I need a straightforward way to grab the data, confirm it’s a PDF, and either export it or query it, all without paying for Business Central.
Has anyone done this successfully? Whether using T-SQL, C#, PowerShell, or a reporting tool—any insights on how to handle the file attachments and the typical Business Central table relationships would be super helpful.
Thanks in advance!
