Error while comparing data

[orcodb]

Hello guys!

I've been using the evaluation trial to compare and synchronize data on a deprecated DB we have, to store it in a new machine.

The program itself runs really well, but for some reason, when the table is too big, the server stops, always in the same spot (when it reaches 2.4 million objects approximately, it gives an error, see screenshots).

https://imgur.com/oQgtbBX

Error:

https://imgur.com/cCiHTGT

It translates to: "An attempt was made to move the file pointer before the beginning of the file." The error doesn't say much to be fair, but neither in Output nor the db servers itself, leaves any other message.

https://imgur.com/pIngqsv

We've changed all the timeout values, max packets allowed, maximum size of each packet... But no success.

dbforge version is 7.4.201 and we are using the Standard Version (evaluation).

Let me know if you need further info, I'll provide it. Hopefully you can give us some more insight as we have no clue what could be happening.

Thanks in advance

[alexa]

We will investigate this issue and will answer you as soon as possible.

[alexa]

Could you please provide us the versions of the Source and Target servers and perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.

Also, if possible, please try to determine the object that caused the error (it should be mentioned at the end of the log file) and provide us its CREATE definitions for both Source and Target.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

[orcodb]

Hi alexa!

Thanks for reaching out.

I uninstalled the standard version yesterday, and today I saw your comment so I installed the enterprise edition (evaluation still). Now it suddenly works?! It doesn't crash at 2.4 million objects, it just goes without errors!

Is there any limitation on the Standard version for some reason?

Thanks for your help! :)

[alexa]

There is no limitation. it's limited only by the amount of features included https://www.devart.com/dbforge/mysql/st ... tions.html