EVE Online database dump and SQL Server 2012

I previously created a little how-to guide for importing the EVE Online database dump into SQL Server 2008 Express Edition. This is an updated guide for the latest version of SQL Server 2012.
First off, you will need SQL Server 2012. The free SQL Server 2012 Express Edition with Management Tools will suffice and can be downloaded here. There is a 64bit and a 32bit version. I chose 64bit for this guide but have seen mention elsewhere that it may cause problems when linking data with applications that are part of the 32bit version of Microsoft Office. I have had no such problems myself however.
Ashampoo_snap_2012

Once downloaded, 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
You may see this window briefly, just wait for it to finish by itself.
Ashampoo_snap_2012
They should be the defaults but select everything except LocalDB.
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. Click the highlighted drop down list and choose browse.
Ashampoo_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
If the server name isn't already filled in correctly then click the Server name drop down box and 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
For Source, select 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.
Ashampoo_snap_2012
Make sure the file is listed and click OK.
Ashampoo_snap_2012
In Destination the Database field will automatically be filled in. This will be the name of the database you are going to create so you might want to name is something relevant. I renamed it eveonline. Make sure there is a tick under Restore. It should already be ticked by default and click OK.

Ashampoo_snap_2012

Once it has finished executing you will have the following window.
Ashampoo_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.
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 2012 Express Edition 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.

 

Comments

Damn you're good! Just yesterday as I was pulling some PI info out of EVE HQ and lamenting that even that ugly will become a thing of the past, I was thinking I just needed to break down and do this. Now you've supplied the How To. Thank you very much for making it so easy!

Always glad to know I've been useful :) There are still some things that EVE HQ can do that I'm yet to figure out, mainly API related stuff though. They're on my to-do list to find out!

I was tempted to just post "fapfapfapfapfap" over and over again, but I figured I'd just tell you how amazing this guide is for an aspiring server guru. :3

Adainy faps to everything.Cool guide, noise.

Thank you so much for posting this. I've been trying to import the dump for a while without success. But once I discover this guide I got it done in no time at all.In case someone is wondering how to convert a table to a CSV file, simply execute the SELECT query at the end of the guide, right click the result table and select "Save Results As..."

This is an excellent guide. Unfortunately, the links appear to be broken at the moment. I hope you can fix them or else create a downloadable PDF of the page....

Sorry, I've only just noticed your post. I'll fix it up soon.

--edit. All fixed up!

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.