Comments
Sort by recent activity
I am not using the 'Compress temporary files' option. The physical memory of the application peaked at around 750 MB. The virtual memory reached around 1.25 GB at the point the exception was generated.
The good news is, I only need to perform this data move one time to get it all on the new server. Judging by the time it took for SQL Data Compare to get to the 27% completion point, it will take about the same time to copy the compressed backup over the network. Of course, I have SQL Backup to thank for that.
I appreciate your assistance with this issue. I am obviously missing something in the database that is just huge. I honestly didn't expect the compare to work, so I am glad to see that it got as far as it did. Imagine the size of the script file it would have generated for all that binary data. / comments
I am not using the 'Compress temporary files' option. The physical memory of the application peaked at around 750 MB. The virtual memory reached around 1.25 GB at the point the exception was genera...
Thanks for the reply, Chris.
You are describing a similar scenario that I am dealing with. I am tasked with moving a database to a new server with minimal downtime for the application. It is a 3rd party application/database, so I can luckily point the finger elsewhere. The data files exceed 50 GB, so dragging them over the network will take time (about 45 minutes in my test environment).
Naturally, I turned to SQL Data Compare as a nice way to catch the new server up with changes since the backup/restore until we "flip the switch" to the new server. The issue is, there were huge BLOBS in the DB (around 600 MB on 1 row) until I had those rows removed from the DB.
Now, the largest row in either DB is around 100 MB according to the datalength function for the only image column in the table. Yet, I am still receiving the OutOfMemoryException on during comparisons on that table. I have 137 GB free on my primary drive. I changed the RGTEMP environment variable to verify that the temporary files were being used during the comparisons.
Can you offer me any other suggestions on circumventing this issue?
Thanks for some great applications! / comments
Thanks for the reply, Chris.
You are describing a similar scenario that I am dealing with. I am tasked with moving a database to a new server with minimal downtime for the application. It is a 3rd ...