SDAC Equivalent to BDE TBatchMove Component

[lcoelho]

Hi,

What is the workaround in SDAC to simulate the BDE TBatchMove component?

Thank you,

[Dimon]

The analogue of TBatchMove is the TCRBatchMove component. Use the TCRBatchMove component to copy server table records to client table or to delete client records that match records in server dataset.
You can find more detailed information about it in the SDAC Help.

[lcoelho]

Hi, thank you for the workaround to BDE BatchMove. However, the mode that I particularly need is the BDE's TBatchMove batCopy mode. This mode creates the destination table based on the structure of the source table. If the destination already exists, the operation will delete it, and replace it with the new copy of the source.

With the SDAC TCRBatchMove component, this mode does not exist or is there another property or option that needs to be selected?

Thank you

[AndreyZ]

The TCRBatchMove component doesn't have such functionality because it can transfer data between tables from different databases. In this case it's impossible to create tables dynamically. You should create the new table on your own and copy data to it using the TCRBatchMove component.
Also you can use the following code to create a copy of a table on a server:

Code: Select all

MSQuery.SQL.Text := 'select * into tablename_copy from tablename';
MSQuery.Execute;

But note that in this case constraints and indexes are not copied.