scottseitz
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ChrisKing, I think you got it right the first time.
leonstryker, that is just TOO SCARY to think that DBA would ask someone to decode a dump file :)
I agree, I think it may be a simple case of misunderstanding of what the DBA implied by a "dump". :)
what they are suggesting is that they want you to restore that DUMP to a local sybase server and do your stuff from there