I have a requirement where I have to compare data between two tables from two different Azure SQL DB's. Both the database have same schema so i just need to compare the data. What are all the options i have since i cant do a cross SQL querying in Azure SQL? Any help is appreciated!!!
I would first try the tablediff utility, perhaps running on an Azure VM.