Options
Disk Space Issues
dnelson3
Posts: 2 New member
Greetings,
I'm trying to run data compare between 2 databases. They're both nearly 400GB between mdf/ldf. I don't have disk space, nor the need to compare the entire databases. Is there a way to run the compare on a subset of tables? When I go to 'Tables & Views', it starts building a list, but gets to 'Applying your mappings 0%' and just hangs up.
Any advice?
I'm trying to run data compare between 2 databases. They're both nearly 400GB between mdf/ldf. I don't have disk space, nor the need to compare the entire databases. Is there a way to run the compare on a subset of tables? When I go to 'Tables & Views', it starts building a list, but gets to 'Applying your mappings 0%' and just hangs up.
Any advice?
Comments
Thanks for contacting us and sorry you are having this issue!
It looks like you cannot do table filtering right now (because you cannot get to Tables and Views) so you might need to change the location of the temporary files to an attached 1tb hard drive (usb or regular Sata - whatever works for you). https://documentation.red-gate.com/display/SDC12/Improving+the+performance+of+SQL+Data+Compare
Also you can turn on logging and send in the log file, we might be able to figure out where or why it is hanging. https://documentation.red-gate.com/display/SDC12/Logging+and+log+files
Thanks!
Technical Sales Engineer
Redgate Software