I've got a .bak file from an HR software we used to use and have been asked to review the contents. I've never done this before, so I've pieced things together from research. So far, I've installed SQL Server 2008 R2 w/ Management Studio and managed to Restore the database from the .bak file.
I've got it in there, but don't know what I'm looking at, how to get the data in a viewable format, export it as .sql, .csv or anything. Not really sure what the next step is to view this in an understandable format. Need a push in the right direction.
Best How To :
With your knowledge with databases, I suggest you follow the following steps to extract a table to Excel
- From object explorer, open databases by clicking the plus sign on Databases folder
- You will see many databases. Click the plus sign for any of them.
- Open a folder called Tables, you will see the data tables in that database.
- Click on
CTLR + N with the database name selected.
- A query editor will open. Type
SELECT * FROM TableName. You need to replace
TableName with the Name of the table you want to explore.
F5. This will display data for you in a grid at the bottom.
- Right click on the top left of the data that you see and click on Copy with Header.
- Go to an excel sheet and paste the data.
This is the way to do it table by table. But you are highly encouraged to consult with a database developer or colleague with database knowledge if you want to learn how to manipulate data inside management studio. This Link might be helpful for you http://www.w3schools.com/sql/sql_intro.asp
Hope this will help.