Activity overview
Latest activity by Wor-Wic-Webmaster
SQL Syntax Error on Script Generated by Compare
I have a particular stored procedure that is always showing up as a new object when comparing to a scripts folder. The reason is that the script in the folder is always showing a SQL syntax error o...
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 ...
Is AWE supported?
Hello.
Regarding this KB article, does SQL Data Compare 7 support Address Windowing Extensions (AWE) for 32-bit systems that have more than 2 GB of RAM?
In my case, we have 32 GB of RAM and I've se...