Evaluation of disk space constraints

SteveRezhener

SQL Data Compare fails to correctly evaluate disk space constraints when syncing large databases (20GB+ databases). It "eats" up disk space and fails in the middle after hours of syncing. :shock:

Chris Auckland

Thanks for your post.

SQL Data Compare doesn't attempt to calculate the disk space requirements to execute the script on your database, as factors such as compression and the location of the data files would also need to be considered.

We have some advice that will help you to understand the disk space requirements necessary for a comparison and to create the synchronization script here. SQL Data Compare can create some large temporary files if you're comparing a lot of data.

I hope this helps.