Tag Archives: SQL Compare

Setting Defaults for New SQL Compare Projects

Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went looking for how to set this as a default. It wasn’t obvious to me, but since … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Ignoring Comments in SQL Compare

Recently I had a client that wanted to know how they could use SQL Compare to catch actual changes in their code, but not have comments show up as changes. This is fairly easy to do, and this post looks … Continue reading

Posted in Blog | Tagged , , | 1 Comment

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 … Continue reading

Posted in Blog | Tagged , , | Comments Off on Adding ApplicationIntent=readonly to SQL Data Compare

Exchanging Schemas with SQL Compare Snapshots

Recently I was working with a customer and they asked if they could somehow package up their schema without the data and send this to a colleague. Absolutely, and that’s one reason we have SQL Compare snapshots. Here’s a quick … Continue reading

Posted in Blog | Tagged , , | Comments Off on Exchanging Schemas with SQL Compare Snapshots