EVE Online database dump
Posted by noise on Saturday, 24 March 2012
If you're a geek like me, and lets face it EVE players are geekier than most, then you might be interested in the inner workings of our virtual galaxy New Eden. CCP provide quite a sizable Data Export for importing into SQL* Server which will give you a hell of a lot of detail about many things such as items, solar systems, stations, blueprints and many many many more.
Here, i'm just going to run through the simple process of getting the dump imported.
-edit: I have updated this guide for SQL Server 2012 which can be found here.
First off, you will need SQL Server 2008. The free SQL Server 2008 R2 Express Edition with Management Tools will suffice and can be downloaded here (SQLEXPRWT_x86_ENU.exe).
Run the installer and choose the highlighted options to start installation.
Then accept the license terms (after reading them thoroughly of course).
Click Select ALL and install all of the features.
You can leave these options at default, unless you specifically want to use a name or want to have the instance installed in a different location.
You need to specify what account will run the SQL Server. If you leave it at it's default then you may encounter some problems when importing the EVE Online database dump. You can create a whole new user account that will only run SQL Server services if you wish but for simplicity, I will just use my standard login. Choose Browse from the highlighted drop down list.
Then type in the account name you want to run the service and click OK.
Then enter your account password and click Next.
You probably wont be accessing this instance from any other PC's so you can just use the Windows authentication mode. If you do select Mixed Mode, you will be asked to provide the SA password.
You can skip through this screen.
Installation will happen, sometimes it will take a while. Just give it time.
And then finally you you will see this which means installation has been completed.
Now that SQL Server has been installed, it's time to download the database dump. Go here and download the link with the arrow (obviously the first part of the file name will change with expansions).
Once it has downloaded you will need to extract the files.
We now have the relevant software installed and the files downloaded it's time to go about importing the database dump into SQL Server.
You will need to launch SQL Server Management Studio from the Windows Start menu.
You should be presented with the following pop-up window (as well as the main management window).
Click <Browse for more...> which will bring up another window where you will need to expand Database Engine and select the item listed.
Then press Connect to be connected to your SQL Server.
Once connected you will presented with the following window.
Right click on Databases and choose Restore Database.
In the window that appears type in the name that you want to call the database. Here I have called it eveonline. Then you need to select From device and click the browse button.
The Backup media should be set to File already, if it isn't then select it. Then click Add.
Find the directory you extracted the database dump to and select the .bak file then click OK.
Make sure the file is listed and click OK.
Put a tick under Restore as it is not ticked by default and click OK.
Once it has finished executing you will have the following window.
If you now expand the eveonline database and then the Tables folder you will see all of the tables from the data dump. You might want to unpin the Solution Explorer while you are here as the express edition doesn't allow you to create projects rendering the window useless. Once you've done that you can unpin the properties window as well.
To finish we'll create a query as a test. Within the Tables folder right click on dbo.chrAttributes and then click (or hover) Script Tables as. Click (or hover) SELECT to and click New Query Editor Window.
This will give you the following screen which has created a SQL query for you, relevant to the chosen database and table.
Clicking Execute will run the query and produce these results.
Congratulations. You have installed SQL Server 2008 R2 with Management Tools, imported the EVE Online database dump and run your first SQL query.
To follow from here, Blake Armitage has written an awesome guide to get you started with some SQL queries.
*I pronounce it sequel, what about you? If you disagree with me then please let me know how do you pronounce SCSI, JPG, GIF or WYSIWYG? Plus it's easier to say than ess-que-ell.