×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

import *.dbs (sql Windows format) database

import *.dbs (sql Windows format) database

import *.dbs (sql Windows format) database

(OP)
One of our sites needs to convert a database (.dbs file) "to ASCII or something else (MSAccess, etc.)".  They tell me that this is a sql database file generated from ENTEK/IRD Odyssey software for motor vibration analysis.
I haven't run across any information on how to import or open this file with any software outside of Odyssey.  I'm not familiar with Odyssey, either.
Any suggestions?
Thanks.
Replies continue below

Recommended for you

RE: import *.dbs (sql Windows format) database

It all depends on how the file was written.  Try opening the file in notepad and see what it says.  It may simply be a csv file or something.  If it's not it may have info at the top of the file that will tell you what format it's in.

It may be a propritory format that only Odyssey understands.  If that's the case hopefully Odyssey has a way to export to CSV or some other standard file structer.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible.  All it takes is a little research. (Me)


http://www.mrdenny.com (My very old site)

RE: import *.dbs (sql Windows format) database

If you can connect to the database via ODBC there is a product called SQLWays available at www.ispirer.com.  I use it to convert data from Dataflex to Oracle.

HTH,

William Chadbourne
Oracle DBA

RE: import *.dbs (sql Windows format) database

(OP)
I was able to open the file with a hex editor (not notepad), but didn't see anything helpful.
The user doesn't know if it's possible to set up an odbc data source- we could also use that to pull the data directly into Access or Excel.  He's checking with Odyssey now.  I'll check out SQLWays to see if that's a better option for us than Access or Excel.
Thanks for the suggestions.

RE: import *.dbs (sql Windows format) database

(OP)
fyi... Odyssey software will help with resolution on this- apparently it's not something we can/will learn how to do.
Thanks for you suggestions.

RE: import *.dbs (sql Windows format) database

I wonder why someone tries to convert the data from Entek/IRD to access. They want to re-invent the wheel?
This type of software receives data generated in handheld vibration analyzers from different vendors, So there is an industrial standard. Probably some computer geek busy doing miracles and not grasping the underlying technology.

Steven

RE: import *.dbs (sql Windows format) database

"SQLBase" from Gupta worldwide uses a ".dbs" file to store its database.  They have a demo SQL Server you can download in try to import your .dbs file.  You can find them at http://www.guptaworldwide.com/  
Good Luck
Mark
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close