I have Used Redgate SQL compare Product in my project .
I have also used Redgate SQL Prompt,SQL compare,data Compare , Monitor ,Data Generator, and mainly index manager .
We used SQL data compare project between a On-prem SQL server and Azure SQL database and executed Successfully . Please check my CV regarding the same .
I could help you a lot in this project . Please Ping me if interested .