exporting data from Oracle to MsSqlServer

[bobbygm]

Hi everyone,

I'm writing a simple Delphi 7 application to export data from some Oracle tables to the correspondant MsSqlServer ones.

The MSS tables already exist, are empty, and were created with the same structure and relationships of the former Oracle tables, but eventually with different names.

So, for instance, I have to copy all records from an Oracle table "Products" to a MSS table "Objects".

The question is: what is the simplest and fastets way to achieve the goal?

I'm trying to use 2 sqlconnection and 2 sqltable comps from DbExpress, but I don't know how to export data

(obviously, I want to avoid doing multiple SELECT and INSERT INTO... VALUES for each table).

Can you help me? Thank you very much

Emanuele

 

[schu]

MS SQLServer has a tool to do this kind of thing.
It is allows import and export of databases, excel files, text files etc.
I cannot rememeber what it is called (used it about 5 years ago) but it should be in the menus. It takes about 30 mins to learn and is quite fast. There are options to empty the table, or append etc. It is actually quite good and fast.

 

[schu]

If for some reason you must use Delphi, I think there is a BatchMove component which can be used to move data from one table to another (again with append, overwrite options). I have only used it in simple Paradox tables so I do not know its performance or reliability with large databases.