Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I get a Sybase table contents into an ascii file?

Status
Not open for further replies.
stevecal

stevecal

Technical User
May 10, 2000
78
DK
I have a syb 11 db to look at tomorrow. I'd like to export a couple of the tables' contents to ascii for a trial upload to an Oracle db. What's the best way to do it? Help appreciated.

 
Sort by date Sort by votes
Hiya Steve,

Why don't you try BCP'ing the data out. The format that you need is

BCP database.owner.table OUT host-file-name -c -Sserver_name -Uuser_name -t'field_delimiter'

Should produce you a nice ASCII file that Oracle can work with.

Tim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question
Need help with SQL query to update a Micros report
Replies
0
Views
659
AM_WG
AM_WG
raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
353
raphael75
raphael75
yelizavetayr
  • Locked
  • Question
Sybase/Infomaker field dependency
Replies
0
Views
390
yelizavetayr
yelizavetayr
JeanTheresa
  • Locked
  • Question
PowerBuilder 6 and Sybase SQL Anywhere Studio 6.0.3
Replies
0
Views
321
JeanTheresa
JeanTheresa
bokswager
  • Locked
  • Question
modifying column on large table
Replies
0
Views
317
bokswager
bokswager

Part and Inventory Search

Sponsor

Back
Top