Devart Forums

Hi,

I cannot copy a table with CRBatchMove and SQL-Server.

My settings are:
The other properties are standard.

When I start MyBatchmove.Execute nothing happens. No record in the destination table, no exception, nothing to see in DBMonitor.

The same code works with Oracle and InterBase.

I tried this with Delphi 7, UniDAC 3.50.013, InterBase XE, Oracle 8.0.5 and SQL-Server 2008 RC2.

My Question: How can I use CRBatchmove with SQL-Server?

Kind regards,
Gerd Brinkmann
invent GmbH

Hello,

I cannot reproduce the problem. Please check that you set the Source and Destination properties to right components. If these properties are set correctly, please specify the exact components that you are assigning to them.

Hello,

thanks for your reply. It was my fault. I thought, that CRBatchmove works with tables, but it moves datasets. Because Sql-Server is very slow in table.open with large tables, i set FilterSql. Bad mistake! Sorry.

BTW: Please allow me another question. I learned, CRBatchmove transfers records between datasets. Is it possible to use datasets from different connections? So can I take CRBathcmove to transfer data from Oracle to Sql-Server?

Kind regrads,
Gerd Brinkmann
invent GmbH

You can use the TCRBatchMove component to transfer data from Oracle to SQL Server if you are using non-server-specific types.