Lesson Learned #172: ApplicationIntent=Readonly in General Purpose database tier?

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

I saw in several situations that our customers are trying to use applicationIntent=Readonly parameter in their connectionstring, but, I would like to mention that this only applies when you have available and enabled ReadScale in Business Critical, HyperScale or Premium database tier. 

 

If you using ApplicationIntent=ReadOnly for database tiers, like basic, standard or general purpose the connection will be possible, but, instead of connecting to the read only replica will be directly to the primary one in readwrite model. 

 

Enjoy!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.