Problems with CRBatchMove and SQL-Server

invent · Post by **invent** » Fri 04 Mar 2011 14:39

Hi,

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

My settings are:

    
    MyBatchMove.FieldMappingMode := mmFieldName;
    MyBatchMove.CommitCount      := 50000;

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

AndreyZ · Post by **AndreyZ** » Fri 04 Mar 2011 15:37

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.

invent · Post by **invent** » Tue 15 Mar 2011 10:18

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

AndreyZ · Post by **AndreyZ** » Tue 15 Mar 2011 15:35

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