Convert old DB

[pdanes]

This is not strictly about Access, but there are some very smart and experienced people here, so I'm going to take a shot.

Someone gave me an old database file, with a .DBS extension. Supposedly created either with something called Gupta SQLBase, or SyBase. I've been looking all over for convertors, ODBC drives and similar stuff, but haven't been able to open it. I will happily send it, if someone wants to take a look, but it's about 60 MB (9 MB zipped) - too big to attach here.

I've looked at it with a hex editor - no engine names that I recognize, but some headers, like SYSADM.SYS$INDEX0, SYSCOMMANDS, SYSROWIDLISTS, SYSVIEWS, SYSSYNONYMS and similar stuff.

None of my existing ODBC drivers are even willing to try it, and no convertor program I've tried so far has had any luck. Anybody have an idea, or want to try their luck?

 

[Isaac]

Sure!

 

[The_Doc_Man]

Based on quick-and-dirty web searches, Sybase is owned by SAP, so you might try contacting them.

The SYBASE format DB was, if my memory serves well, created by the engineers of ShareBase, a DB server-class SQL engine from the 1980s-2000s that willingly talked to DEC equipment. Initially, it was a product of a company called Signal Technologies, but after typical corporate gyrations, that DB division became ShareBase... which eventually folded and was reborn as SYBASE. But with declining popularity, they reportedly have stopped their development cycle in 2010. Which places SYBASE in a "legacy" status.

I worked around a ShareBase DB for a while with the U.S. Navy, but when that company upended themselves, I had to reverse engineer the ShareBase format in order to translate it to a format ORACLE would take. They didn't have a lot of cross-compatible interfaces back then either. Since they were folding at the time, we got permission to hack their backup format. The formats they DID have were to convert to whomever it was that was buying them out and they either didn't want our business or legally couldn't TAKE government business. I must admit I have forgotten the sordid detail now after 30-35 years.

 

[tvanstiphout]

Not too large to upload to an online file service like OneDrive or DropBox, so interested parties can download it and take a look. I might want to take a crack at it.
What can you tell us about this database? How old is it? Is it a single table, or multiple? What is the subject matter? Is the data encrypted?

 

[pdanes]

Based on quick-and-dirty web searches, Sybase is owned by SAP, so you might try contacting them.

The SYBASE format DB was, if my memory serves well, created by the engineers of ShareBase, a DB server-class SQL engine from the 1980s-2000s that willingly talked to DEC equipment. Initially, it was a product of a company called Signal Technologies, but after typical corporate gyrations, that DB division became ShareBase... which eventually folded and was reborn as SYBASE. But with declining popularity, they reportedly have stopped their development cycle in 2010. Which places SYBASE in a "legacy" status.

I worked around a ShareBase DB for a while with the U.S. Navy, but when that company upended themselves, I had to reverse engineer the ShareBase format in order to translate it to a format ORACLE would take. They didn't have a lot of cross-compatible interfaces back then either. Since they were folding at the time, we got permission to hack their backup format. The formats they DID have were to convert to whomever it was that was buying them out and they either didn't want our business or legally couldn't TAKE government business. I must admit I have forgotten the sordid detail now after 30-35 years.

Ah, yes - fond memories of DEC gear. Second machine I worked on - a PDP 11/70. Pretty hot machine for its time. The first was a Univac 9300.

I've looked at the SAP site, hoping to find a convertor, but no luck. I can try writing them. Worst case, they'll tell me to go fly a kite.

 

[pdanes]

IIRC, a .DBS extension could be Informix, or dBase file. Is that the only file when you unzip? The SYS$ files suggest they're system catalog files of an ANSI/SQL based db server. What do the file properties say about the author, dates, etc?

I got it already unzipped. I've zipped it to send to a guy who volunteered to look at it. Hadn't considered Informix, but I just now found something called RazorSQL, which promises to be able to open such stuff. We'll see.

File properties unfortunately say nothing. I got it via a file transfer site, and it is now just a binary Windows file, with me as the author and the download date as the creation date. No other information attached to it.

 

[pdanes]

Not too large to upload to an online file service like OneDrive or DropBox, so interested parties can download it and take a look. I might want to take a crack at it.
What can you tell us about this database? How old is it? Is it a single table, or multiple? What is the subject matter? Is the data encrypted?

Sadly, I know nothing at all about it. The owner just asked if I could open it, since I had done something similar for a friend of his, but he didn't tell me anything about what is supposed to be in it. I didn't ask, either. If I can open it, I'll see what's inside. If not, knowing what should be in there isn't going to help me.

Here is the link to where I sent it to my first volunteer: https://we.tl/t-yuLN7V5HuI

 

[pdanes]

I have a tool that can read multiple types of btree files, so please post the link to the online platform that you stored it in so we can dissect it.

Here you go: https://we.tl/t-yuLN7V5HuI

 

[pdanes]

Razor opens Informix C-ISAM .idx and their corresponding.dat files. I have seen SYS$ prefix filenames before on DEC VAX/VMS db's such as Informix and Oracle.

Just tried it - no luck. It opens the file once, but displays mostly hash. A few things are in clear text, like the SYS stuff, but very little. When I close it and try opening it again, hoping to try a different encoding, it whines that the file is too big for Razor to open - the same file that it just opened earlier. Closing and restarting Razor does this again - opens once, display crap, then refuses subsequent re-opens.

 

[tvanstiphout]

I see SYSTABCONSTRAINTS, which points to SQLBase, according to Google.

 

[sonic8]

But with declining popularity, they reportedly have stopped their development cycle in 2010. Which places SYBASE in a "legacy" status.

When SAP bought Sybase in 2010(?) they rebranded Sybase ASE as SAP ASE and continued development, albeit slowly.
I've got a customer who is just now in the process of upgrading their fairly old Sybase database server to SAP ASE version 16 (probably v16.1).
SAP ASE 16.1 was released in 2023 and has mainstream support until 2030. So, it's definitely not a legacy product, even though SAP currently shows little interest to invest much into further development.

 

[pdanes]

I did a hex dump and the data is in Czech language. I saw SQL System Catalog names and "PCTFREE" which I have seen used as Oracle index file directives when creating tables. The initial data towards the begining of the file has a similar signature to other Oracle VAX/VMS versions I have seen in the past.

View attachment 122044

That language part is correct. I am working in Prague, and the owner is a local person. But the Oracle bit seems off to me. Nobody involved in this is likely to have used such a sledgehammer, or even been able to afford it, especially as far back as this is claimed to have originated.

But if so, how would I extract it? Everything I know about Oracle, which is admittedly not much, is that it is a server database, not anything that would create a single database file the way Access and FoxPro do. I just now looked around for anything like an Oracle file convertor, and found nothing that looks helpful.

You managed to get some of the table descriptions, which is more than I have yet managed. There are remarks about table of vehicles, table of people in vehicle, table of accidents...

 

[pdanes]

I thought Microsoft bought out Sybase and used it to develop SQL-Server back in the early 1990's?

I have no idea about that, but I wouldn't be surprised - they did a lot of things like that. Do you know what you customer is using for his migration project?

 

[tvanstiphout]

> it is a server database, not anything that would create a single database file
Actually, that is not impossible. SQL Server uses 1 file for the entire database (OK, and a Log file, and you CAN use multiple files).

You would need a SQLBase or similar server installation, then try to mount this file.

 

[pdanes]

I'm currently not migrating any customer's data. You first have to get the db server, or tool, that can read that file so you can export the data to a csv text file.

Yeah, I know. That's what I'm trying to do, and is the reason for this entire thread. I thought maybe your customer is migrating his data, and if so, you might know what he is using.

 

[pdanes]

> it is a server database, not anything that would create a single database file
Actually, that is not impossible. SQL Server uses 1 file for the entire database (OK, and a Log file, and you CAN use multiple files).

You would need a SQLBase or similar server installation, then try to mount this file.

I suppose, although the raw file is rather inaccessible to mere mortals. I work with SQL Server as a data source for Access, and I know of nothing that would just read data from the .mdf files that SQL Server works with. Maybe there is something - I just have never sen anything like that. I've always had to attach the .mdf file to a working instance of the engine to get anything from them.

I just found and tried something called DataGrip. Opens the file, but display mostly garbage.

 

[pdanes]

Try SQLBase since its a DBS filetype. There are other tools, such as SQL Anywhere which could also open it. Where are you planning to migrate the data to?

Gupta was mentioned as one of the possible architectures by the owner. I'm looking at their website, but see nothing like a file convertor. I can try writing them.

What I will do with it depends largely on what I find inside. If it's simple, I suppose just a flat file export. If it's more involved, I will try to convert it to Access, or maybe even SQL Server. The owner hasn't asked for anything specific so far, just wanted me to see if I could open it.

 

[Jason Lee Hayes]

IDA

This is not strictly about Access, but there are some very smart and experienced people here, so I'm going to take a shot.

Someone gave me an old database file, with a .DBS extension. Supposedly created either with something called Gupta SQLBase, or SyBase. I've been looking all over for convertors, ODBC drives and similar stuff, but haven't been able to open it. I will happily send it, if someone wants to take a look, but it's about 60 MB (9 MB zipped) - too big to attach here.

I've looked at it with a hex editor - no engine names that I recognize, but some headers, like SYSADM.SYS$INDEX0, SYSCOMMANDS, SYSROWIDLISTS, SYSVIEWS, SYSSYNONYMS and similar stuff.

None of my existing ODBC drivers are even willing to try it, and no convertor program I've tried so far has had any luck. Anybody have an idea, or want to try their luck

 

[Jason Lee Hayes]

Consider this:

Gupta SQLBase (English) | Full Convert

Gupta SQLBase database is fully supported by Full Convert. You can easily import data into Gupta SQLBase from more than 40 databases and export data from Gupta SQLBase to more than 30 databases.

www.fullconvert.com

Supports DBS files natively

Using a hex editor will be pretty useless - even with IDA Pro in the right hands which is the tool to have will only give you byte pattern mapping & system table markers……

 

[pdanes]

Consider this:

Gupta SQLBase (English) | Full Convert

Gupta SQLBase database is fully supported by Full Convert. You can easily import data into Gupta SQLBase from more than 40 databases and export data from Gupta SQLBase to more than 30 databases.

www.fullconvert.com

Supports DBS files natively

Using a hex editor will be pretty useless - even with IDA Pro in the right hands which is the tool to have will only give you byte pattern mapping & system table markers……

Trying that, but no luck with it so far. All it says is 'Please download the trial again and reinstall.' Three times, same result.