Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
MyFingID
Perkone Caldari State
0
|
Posted - 2012.08.25 21:20:00 -
[1] - Quote
Does anyone know where I can find a copy of the database that is NOT is SQL format? I've been ******* with SQL here and there for days and still cannot open the file. I'm sick of trying and just want to access the information in a reasonable format. I don't care if it's a webpage, a text file, XML, or whatever just some sort of accessible file format. I have no idea why it was released in SQL format to begin with; it really seems like pretty much any other format would have been more accessible. Not everyone who is trying to access information is running a webmaster/running a SQL server. |
Vessper
Kardinal Resource Manufacturing
15
|
Posted - 2012.08.25 21:49:00 -
[2] - Quote
Try https://forums.eveonline.com/default.aspx?g=posts&t=141711&find=unread
The guy is pretty much on the ball with conversions of all Eve patches so worth following after an update.
|
Lutz Major
Austriae Est Imperare Orbi Universo
290
|
Posted - 2012.08.26 09:58:00 -
[3] - Quote
Yeah, you are right. It is totally bogus to store information in a sql database. CCP should export its data into an Excel file. |
Durzel
The Xenodus Initiative.
57
|
Posted - 2012.08.26 13:02:00 -
[4] - Quote
An Excel 2010 .xlsx file no less. |
Steve Ronuken
Fuzzwork Enterprises
582
|
Posted - 2012.08.26 15:11:00 -
[5] - Quote
To use the database export:
Download SQL Server Express with tools. (get the appropriate one for your OS architecture. 64 bit or 32 bit) http://www.microsoft.com/en-us/download/details.aspx?id=22973
Install it, making sure you select the management tools as well.
Unzip the export file. Pick somewhere other than /your/ my documents (It won't be running as your main user. So somewhere like c:\ is suitable for short term storage)
Open up the management studio and connect to the db.
The server name should be .\sqlexpress If you didn't futz with the install settings, windows authentication should be fine.
right click on databases. Select 'restore database'
click the 'from device' radio button. hit the button with the ellipsis. hit add. find the file you unzipped to and select it. Hit ok a bunch of times to get it to restore.
Tada, DB restored and working.
The DB really is the best way to store this information, as it's very relational. You're going to, if you use the xls files, do a great deal of vlookups.
If you can't be bothered with slq server, there's always the mysql conversion. The process is a trifle simpler. (install it. log in. create a database. Pipe the backup into that database) FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |