Revision3.com Shows Schedule Inside Revision3 Store


Go Back   Revision3 Forums > Shows > HAK5

Reply
 
Thread Tools Search this Thread Display Modes

  #1  
Old 05-07-2011, 10:09 PM
mickeymutt
Newbie
 
Join Date: Dec 2008
Posts: 15
Status: Offline
Default SQL help

Is there any way I can open a sql file? I had an a program that used a sql file to store my data. The cost went from zero to $1500 a year for subscription. Which I can't afford now. I have 20 years of customer data, job specifications and production costs in that file. Is there a away to open the file so I can read the information?
I applicate any help anyone can give me.

Aloha,

Mickey Mutt
Reply With Quote
  #2  
Old 05-08-2011, 03:06 AM
tokenuser's Avatar
tokenuser
Cranky Old Mod
 
Join Date: Jul 2005
Location: Lost in States
Posts: 15,125
Status: Offline
Default

An SQL file?
You mean a database right?
SQL is the language used to access the database.
The format the file is stored is proprietary to the vendor.

Ms access can be accessed by SQL.
Oracle, IBM db2, mySQL, postgres ... All programs that can use SQL to access the files. If it was a proprietary windows app, then there is a good chance it was a MS Access format file (Potentially a JET driver if it was an old enough program).

Without knowing the underlying database, then you are kinda hosed.
Once you do know, you can install an appropriate odbc driver and access the file from excel.
__________________
“Simplicity is the ultimate sophistication.” - Leonardo da Vinci
"I am a firm believer in the people. If given the truth they can be depended upon to meet any national crisis. The great point is to bring them the real facts...and beer." - Abraham Lincoln
"... connect the dots instead of assembling a jigsaw puzzle." - Wil Wheaton
Reply With Quote
  #3  
Old 05-08-2011, 08:15 AM
tehboris's Avatar
tehboris
Elite Member
 
Join Date: Jun 2007
Location: England
Posts: 1,532
Status: Offline
Default

Alternatively, you might be able to straight up open the file in a text editor and 'see' the data.

If that is the case you should be able to processing the data to turn it in to a CSV or similar which can then be imported in to any database quite easily regardless of the original database used.
__________________
Steam: http://steamcommunity.com/id/tehboris

Last edited by tehboris : 05-08-2011 at 08:15 AM.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT. The time now is 11:53 PM.

Rev3 Forum RSS


© 2005-2010 Revision3 Corporation