Hey!

I work for Redgate, just wanted to state that up front.

Instead of using Compare and Data Compare, have you tried looking at SQL Source Control? It...

It does. It's called merge replication, but it's more than a little bit difficult to implement and maintain. The showstopper for most people is that one of the first requirements...

So, if one is read only and the other is not... How high volume is the database with writes? If the volume is relatively low, you could use transactional replication...

Maybe it's your query. You have columns in the WHERE clause for a table in a LEFT JOIN. Move those out of the WHERE clause up to the JOIN criteria...

Here's some great documentation on what's supported within Azure SQL Database for compression. That should fill in all the gaps.

Yeah, I don't have an immediate answer to that one, sorry.

This is a three year old question without an answer.

I haven't had to deal with service broker, but if I did and I was using SSDT, I'd suggest...

Well, every team I was rooting for is out of the cup. We're down to "Not France" in my house.

How has everyone else been?

The ISNULL command is absolutely going to lead to table scans with no possibility of seeks. You need to get rid of it. If you have to use an OR...

There you go. Multiple threads.

Did either of the queries execute in parallel?

Also, look at the execution plans, specifically the ANSI settings (located in the first operator's properties). See if they're different. That could result in differences in data depending on the...

I agree with everyone else, if you really want help, make it easier for us to read this.

I took the time to scroll through it a little bit....