Read large data from Azure SQL DB into Onpremise application

Question

Hi,

I have a WCF REST application in Azure inserts data into Azure SQL DB. This DB has rows having XML columns about 2-3MB base64text data.

My On premise custom application reads data from Azure SQL and I added my on premise IP address added in Azure SQL firewall rules.

1) when reading data of small sizes say (<2MB), I can get the data

2) When reading data of large size, my code says "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"

Can anybody please tell me what is going wrong here? Any best practice while connecting to Azure SQL DB from on premise code?

Answer 1

Hi anilvem1,

Wouldn't it make more sense to store the XML data as Blobs instead? And in your DB, you would just store a reference (BlobId) to that XML Blob?

---

Best Regards,
Carlos Sardo

Answer 2

Thanks Carlos.

I will try this. :)

Thanks
AnilVem