April 13, 2008 at 11:28 pm
My friend and I are coding an addon in python to replace an older addon written in a different langauge.
We want to extract the info the old addon's sqldb file. However, I have no clue what to do. I do not know what to open a sqldb file with to view its contents, etc.
Afterwards, I need to make some type of script that will pull out the info, etc.
Thanks for any help you can give me,
Josh
April 15, 2008 at 4:12 am
I am sure one of you has some type of basic tips for a person.
Real helpful board...
April 15, 2008 at 4:16 am
It's not really clear what you're trying to do. If you want to open a SQL script file (with a .sql extension), use SQL Server Management Studio.
John
April 15, 2008 at 7:15 am
As John stated, we're not sure what exactly you are trying to do. To simply view the database and it's contents, a suggestion has already been given. If trying to access the data from within your app, what version of SQL are you running? To export the data to a flat file, there are several options open to you. Give us more info and someone can surely help.
-- You can't be late until you show up.
April 15, 2008 at 1:41 pm
The file extension is .sqldb
I believe it is an sql lite database.
I was trying to find a way to view its contents, so that I can attempt to extract the info once I know what the tables are.
April 15, 2008 at 1:49 pm
.sqldb is not the extension of a SQL server database or script. SQLite is not in any way related to SQL Server
Perhaps the SQLDB viewer on this page will help you?
http://extramind.com/downloads.htm
Or the Sqlite home page/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 15, 2008 at 1:52 pm
Here is SQLite's website. They have some downloads that may be of use.
http://www.sqlite.org/download.html
-- You can't be late until you show up.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply