Importing datagreenspun.com : LUSENET : SQL Server Database Administration : One Thread |
How can I import data stored in Oracle to MS SQL server?
-- Anonymous, October 09, 1997
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
What is bcp?
-- Anonymous, October 09, 1997
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