SQL Data Sync - Matt Mansoomi

Matt Mansoomi

SQL Data Sync

A collection of 2 posts

Connection issue for DataSync

Connection issue for DataSync

Before this I talked a bit about DataSync and how to troubleshoot some popular errors and issues, A few weeks back I got client with DataSync issue again, basically they got connection issue when tried to sync data, here was the error message: SQLError Number:40532, Message: Cannot open server

SQL Data Sync troubleshooting

SQL Data Sync troubleshooting

SQL Data Sync is an effective method on Azure that allow you to synchronize the data you select across multiple databases, as Microsoft explains here that’s bi-direction and you can use on both on premises and cloud. Sometimes it can be tricky and goes out of sync. I got