Sybase DB - Have raw DB files and need to export schema (lists of entries of rows and columns) without access to the original front-end interface that created it.

I have been given 2 raw Sybase databases - the .db and .log files for each.  Each .db is under 1.4GB.

We do not have access to the front-end that the database was populated using, and the raw data needs to be accessed so that queries and reports can be made against the data. However, we are unsure of exactly what type of data the DBs hold - we don't know the schema. If we could export the schema, I could present it to the end users on the team and a developer to decide what information is useful to import into a new live DB, what rows and columns are linked, what their labels/names are, etc, etc.

I am a network, Microsoft Server NT - 2012 and Exchange admin (14 years) with very little DB knowledge outside of work in IIS. The Sybase DBs are not live, so I can put then through any type of filter, tool or migration I need to in order to present what it holds and how it holds/organizes the data (containers) to the project manager. I would even import it into SQL or Access if I needed (of course I have a few archived/backup copies of the raw Sybase DBs).

So I am not only looking for the proper tool (we are willing to purchase what we need), but a little hand holding as well - I need to produce the schema of the 2x Sybase databases first. Then I need a tool that will allow us to make queries and generate reports on the data once we know exactly what the data is.

So a little DB 101 - 300 if anyone could.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BudDurlandDirector of ITCommented:
It would help to know what version of Sybase was used to create the databases.  If you go to the Sybase web site, you can download a developer version of Sybase SQL Anywhere for free.  With that installed, you should be able to use the management tools to examine the data structure, and/or export them to flat ASCII files.
mojopojoAuthor Commented:
Thanks. I've downloaded and installed the Sybase dev kit but am having trouble mounting the files I was given as an OBDC Data Source. The problem looks to be that I have the .db and .log files, but the Sybase management consul is looking for a .dsn file.

I have tried with the Sybade dev kit v12 and v16 - both are installed on a test server now that I have full access to.

Any help would be appreciated
BudDurlandDirector of ITCommented:
You should use the desktop (local) database server to open the database & log file.  Copy the .db and .log files to C:\Database.  Then

%SQLANY16%\bin64\dbeng16.exe -n MyServer c:\database\database.db -n MyDatabase

Open in new window

This will start a local database server with the name 'myserver'.  It will open the datbase file and for connection purposes, the database name is 'MyDatabase'

Then when you run Sybase Central, you can tell it 'connect to a database running on the local machine', and provide those names to connect.  Of course, adjust the commands for version 12 as appropriate.
Vitor MontalvãoMSSQL Senior EngineerCommented:
You might need to install a Sybase engine and attach those files there. Problem is what version do you need?
Try the latest version since it usually compatible with previous ones.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mojopojoAuthor Commented:
The encryption key were were given was bad. Once we had the verified and correct key, we installed a full version of the Sybase engine. We were then able to mount the DB and access the data.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.