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.