<div>
I am not sure what you are asking. &nbsp;<br />
<br />
Oracle and SQL Server are two different dbms's.<br />
<br />
Oracle's load utility is SQL Loader.<br />
<br />
SQL Server uses BCP.<br />
<br />
The two load utilities are not compatable. &nbsp;<br />
<br />
If you want to take data from Oracle and load it into SQL Server you can use SQL Loader to extract the data from the table in a tab delimited format and then use BCP to load the data in SQL Server.<br />
<br />
You will need to set up the utilities seperately.<br />
<br />
Hth<br />
<br />
<br />
<br />

</div>


I am not sure what you are asking.  

Oracle and SQL Server are two different dbms's.

Oracle's load utility is SQL Loader.

SQL Server uses BCP.

The two load utilities are not compatable.  

If you want to take data from Oracle and load it into SQL Server you can use SQL Loader to extract the data from the table in a tab delimited format and then use BCP to load the data in SQL Server.

You will need to set up the utilities seperately.

Hth





<div>
Hello JackOfAll1. Thank you.<br />
<br />
I have an ODBC connection setup already. I can use I guess any query utility via this ODBC successfully and I am currently.<br />
<br />
I want to get Table(s) from Oracle and dump them in SQL Server periodically once a week or once a day. That is want I want to do.
</div>


Hello JackOfAll1. Thank you.

I have an ODBC connection setup already. I can use I guess any query utility via this ODBC successfully and I am currently.

I want to get Table(s) from Oracle and dump them in SQL Server periodically once a week or once a day. That is want I want to do.

<div>
<br />
Thank you J.<br />
<br />
can I use that ODBC connection via bcp? if yes a small example I am dying for to find out.
</div>



Thank you J.

can I use that ODBC connection via bcp? if yes a small example I am dying for to find out.

<div>
<div class="content wysiwyg-content">
I am experimenting with ODBC. I want to pull 1 to 2 tables from a database which is in Oracle SQL Server. I connect into this Oracle database server via ODBC.<br />
<br />
Via bcp utility can I? If So any very small exmple to be clear where I must look into? Something says me there is huge incompability between.<br />
<br />
Thanks. Mr_P
</div>
</div>


I am experimenting with ODBC. I want to pull 1 to 2 tables from a database which is in Oracle SQL Server. I connect into this Oracle database server via ODBC.

Via bcp utility can I? If So any very small exmple to be clear where I must look into? Something says me there is huge incompability between.

Thanks. Mr_P

Dump table, column, row via ODBC via bcp

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.