EVE Online database dump

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.
Ashampoo_snap_2012

Then accept the license terms (after reading them thoroughly of course).
Ashampoo_snap_2012

Click Select ALL and install all of the features.
Ashampoo_snap_2012

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.
Ashampoo_snap_2012

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.
0ashampoo_snap_2012

Then type in the account name you want to run the service and click OK.
Ashampoo_snap_2012

Then enter your account password and click Next.
Ashampoo_snap_2012

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.
Ashampoo_snap_2012

You can skip through this screen.
Ashampoo_snap_2012

Installation will happen, sometimes it will take a while. Just give it time.
Ashampoo_snap_2012

And then finally you you will see this which means installation has been completed.
Ashampoo_snap_2012

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). 
Ashampoo_snap_2012

Once it has downloaded you will need to extract the files.
Ashampoo_snap_2012

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.
Ashampoo_snap_2012

You should be presented with the following pop-up window (as well as the main management window).
Ashampoo_snap_2012

Click <Browse for more...> which will bring up another window where you will need to expand Database Engine and select the item listed.
Ashampoo_snap_2012

Then press Connect to be connected to your SQL Server.
Ashampoo_snap_2012

Once connected you will presented with the following window.
Ashampoo_snap_2012

Right click on Databases and choose Restore Database.
Ashampoo_snap_2012

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.
Ashampoo_snap_2012

The Backup media should be set to File already, if it isn't then select it. Then click Add.
Ashampoo_snap_2012

Find the directory you extracted the database dump to and select the .bak file then click OK.
0ashampoo_snap_2012

Make sure the file is listed and click OK.
Ashampoo_snap_2012

Put a tick under Restore as it is not ticked by default and click OK.
Ashampoo_snap_2012

Once it has finished executing you will have the following window.
0ashampoo_snap_2012

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.
Ashampoo_snap_2012

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.
Ashampoo_snap_2012

This will give you the following screen which has created a SQL query for you, relevant to the chosen database and table.
Ashampoo_snap_2012

Clicking Execute will run the query and produce these results.
Ashampoo_snap_2012

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.

Comments

Wow wish i found this sooner, great guide i was stuck at the last part executing the query

Glad you found the guide useful.

This was exactly what i was looking for. Thank you so very much!

I am having a little trouble. When I get to "Put a tick under Restore as it is not ticked by default and click OK." There is nothing to check. When I am on the Select Backup Devices window, I select Contents after selecting my bak file and I get the following error message: System.Data.SqlClient.SqlError: CREATE DATABASE permission denied in database 'master'.Any ideas? I am running the 2012 version, I could not find the 2008 R2 version.Thanks for any and all help...

Hi LastDavid.The link to 2008 R2 is in the second paragraph, I just tested it and it still works: http://www.microsoft.com/download/en/details.aspx?id=23650I haven't tried 2012 yet so can't comment. I will make a point of creating a new guide when I do.

Just a quick comment to say that I've updated this guide for SQL Server 2012. It can be found here:http://phoenixdiaries.co.uk/eve-online-database-dump-and-sql-server-2012..., let me know if you are still having problems.

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
To prevent automated spam submissions leave this field empty.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.