EVE Technology Lab

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.

Yeah, you are right. It is totally bogus to store information in a sql database.
CCP should export its data into an Excel file.

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)