RE: OT: Need help with SQL*Server

Not only BCP..
Create a DTS package to suck it in.. It will allow you to do source to target mapping.. Copy the file over, and have them use the facility to map and import the data via the GUI.

Just an alternative to the good old BCP......

Greg

-----Original Message-----
Sent: Friday, October 31, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L

Sure; bcp is pretty straightforward. It can handle all sorts of formats on the data file (much more flexible than exp/imp or sql*loader in my experience)

I maintain a sybase dba page here:
www.bossconsulting.com/sybase_dba

Click on "my personal faq" link then scroll down to the "bcp specific" pages. there's a few topics in there that you may find interesting.

the basic commands are pretty easy:
% bcp database..table in/out datafile.csv -Uuser -Ppassword -Sservername -c (-c tells you ascii mode). You can also specify a control file, if the data isn't in the most pristine format.

You can also create a test target table for your data on sybase , do a test bcp OUT to get a copy of the control file. Or insert a test record, bcp THAT out and see how bcp expects the data to be formatted.

I suggest taking this offline if you want further help. hope this helps,
boss

>
> OK folks I'm out on the dark side, once again. Does anyone remember how
MicroSlop's BCP utility in SQL*server works? I've got a user who bought a third party SQL*server application, I won't go there, and he needs to move some data from a desktop to a laptop SQL*server database.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Goulet, Dick
> INET: DGoulet_at_vicr.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Todd Boss
  INET: boss_at_i-sphere.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Loughmiller, Greg
  INET: Greg.Loughmiller_at_cingular.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).