OT: Need help with SQL*Server
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: OT: Need help with SQL*Server
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: OT: Need help with SQL*Server
Title: 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- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 31, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: Need help with SQL*Server 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).