How can I import data stored in Oracle to MS SQL server?

-- Anonymous, October 09, 1997

Answers

Re: Importing data from Oracle

Olof,

With Oracle SQLPlus write a SQL statement to write your table to a file (using the spool command) then bcp it into MS SQL server.

Eric

-- Anonymous, October 09, 1997

bcp?

What is bcp?

-- Anonymous, October 09, 1997

Re: bcp?

Bcp is the bulk copy command. It is used to transfer data between database tables and files. It is a fast method of data transfer because it is not logged. That is, the bcp is not treated as a transaction that may need to be rolled back.

Of course, before you can bcp you need to create the schema on the SQL Server first. (Sorry Olof, I forgot to mention that step.)

If you want to transfer data between two SQL Server databases you can use the Database/Object Transfer tool. You can access this from the Tools menu of Microsoft SQL Enterprise Manager.

-- Anonymous, October 10, 1997