Devart Forums

Hello,

I wonder what's the simplest way to copy a table from one SQL Server to another replacing the destination, using SDAC 4.80.

Thanks, Peter

You can use the TCRBatchMove component to copy data from one database to another.
You can find more detailed information about TCRBatchMove in the SDAC Help.

Tomorrow I'll try it.
Thanks !

It works fine, thanks.
Except for that I set
CRBatchMove1.AbortOnKeyViol:=false;
CRBatchMove1.AbortOnProblem:=false;
and it still stops and throws exceptions on such conditions.
Cannot it be overrided some way ?

Thanks, Peter

Please give a more detailed description of the error that arises in your application.

Hi Dimon,

Unfortunately I don't have time momently to investigate this, therefore I solved it another way, regarding the fact that even 1 error makes my process to be unsuccessful.

My other question is there any way to stop the batchmove process programmatically during operation, for example using the OnBatchMoveProgress event ? I didn't find such method in the manual.

Thanks a lot,

Peter

TCRBatchMove doesn't allow to stop process after starting execution.
But you can use the RecordCount property to determine the maximum number of records in the source dataset, that will be applied to the destination dataset.

Hi Dimon,

Can I tell TCRBatchMove to start over where it has left off anyway ?

Thanks for your answer,

Peter

Set the RecordCount property. If RecordCount is greater than 0, up to the RecordCount records are applied to the destination dataset, starting from the current record in the source dataset.

So if I do nothing else to the DataSets than call Execute (optionally) again with RecordCount>0 until RecordCount>MovedCount, that's enough ? This method is safe enough ?

Yes, you can use this method.