Mapping data from SQL 2000 to Oracle .. Possible? Easy?

Ulysses · 13 Sep 2006 at 15:22

Hi,

At work there is a possible scenario looming that would require us to send data from a SQL 2000 database to an Oracle database. In theory is this possible and without going into any serious detail is it achievable fairly easily?

Any help would be welcome!

Uly

rpstewart · 13 Sep 2006 at 16:02

Should be reasonably easy, depends on the volumes of data and the frequency it needs to move.

The simple method for a one off move would be to export the data from SQL Server to a comma separated file with the same column order as the target table in Oracle and then load the file into the Oracle database.

For a more regular move then DTS might be the best option, I think it can do an automated move to Oracle if the target is set up as an ODBC source.

Mind you I could be talking garbage, I'm a DB2 specialist rather than Oracle.

Ulysses · 13 Sep 2006 at 16:04

Cheers rp.

The data would be very frequent, as frequent as possible really but the amount of data would not be much. It would be some result data not a whole database at once.

rpstewart · 13 Sep 2006 at 17:46

DTS is the way to go then, I think you're limited to a timed schedule rather than real time replication of changes though. Even then you should be able to run updates every minute if you want.

Details at this point start getting a bit hazy as I've only ever done DTS from SQL Server to SQL Server and it was a while ago too.