Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 943
  • Last Modified:

Reading Sybase Dump File without Sybase

My problem: I'm an ETL devloper and one of my new data sources is a Sybase database.  I don't have a Sybase server and I can't get query access against the production server.  The plan is to send a copy of the Sybase backup/dump file to me each night.  

I'm not at all familiar with the backup/dump format (or for that matter Sybase).  Will I be able to parse this file with Perl or some other tool to pull all of the data back or will the file only be valuable if I can first load it to a Sybase server and then extract what I need?

Any comments or suggestions would be appreciated.

Thank you.
0
scottseitz
Asked:
scottseitz
  • 3
  • 2
1 Solution
 
ChrisKingCommented:
tell them that you don't want a dump of the database, you want a BCP extract.

BCP can be formatted with any field delimiter and any row delimiter that you want. eg a comma/newline combination would give you as BASIC csv format, but it will not quote string containing commas, so choose your delimiter carefully.
0
 
ChrisKingCommented:
hang 5... I am reading you request too literally
what they are suggesting is that they want you to restore that DUMP to a local sybase server and do your stuff from there
0
 
leonstrykerCommented:
ChrisKing, I think you got it right the first time.
0
 
ChrisKingCommented:
leonstryker, that is just TOO SCARY to think that DBA would ask someone to decode a dump file   :)
0
 
leonstrykerCommented:
I agree, I think it may be a simple case of misunderstanding of what the DBA implied by a "dump". :)
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now