EVE Online database dump and SQL Server 2012
Posted by noise on Sunday, 19 August 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.
Once downloaded, run the installer and choose the highlighted options to start installation.
Then accept the license terms (after reading them thoroughly of course).
You may see this window briefly, just wait for it to finish by itself.
They should be the defaults but select everything except LocalDB.
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. Click the highlighted drop down list and choose browse.
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).
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.
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.
For Source, select 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.
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.
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.
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 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.