Adding ApplicationIntent=readonly to SQL Data Compare

Recently someone asked a good question about SQL Data Compare. How can they add applicationintent to the connection?

If you are using Data Compare, and you are reading from production systems, load is a concern. With Availability Groups (AG), we can point SQL Data Compare to the secondary replicas and limit the load on the writable primary. How can we do that? Well, it’s actually easy.

We have a doc page for encrypted connections, and we can use the same type of action to work with AGs.

In a new project, I typically see something like this:

2020-09-04 12_04_43-New project_

What I can do is edit the server connection on the right. Just click in there, and then add this:

Aristotle\SQL2017;applicationintent=readonly

This will add the option in the connection string.

2020-09-04 11_51_37-New project_

If I open the project file, I will see the XML, where I can also edit these connections if desired.

2020-09-04 12_09_42-E__Documents_SQL Data Compare_SharedProjects_(local)_SQL2017.SimpleTalk_1_Dev v

I can do this for any of the options I need for connection strings.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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