需要查看/转换.bak文件内容 [英] Need to View/Convert .bak file contents

问题描述

我从以前使用的HR软件中获得了一个.bak文件，并被要求检查其内容.我以前从没做过，所以我把研究中的东西拼凑了起来.到目前为止，我已经安装了带有Management Studio的SQL Server 2008 R2，并设法从.bak文件还原数据库.

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.

我已经找到了它，但是不知道我在看什么，如何以可见格式获取数据，将其导出为.sql，.csv或其他任何内容.不太确定下一步是要以一种易于理解的格式查看此内容.需要朝正确的方向推动.

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.

推荐答案

根据您对数据库的了解，建议您按照以下步骤将表提取到Excel

With your knowledge with databases, I suggest you follow the following steps to extract a table to Excel

1. 从对象资源管理器中，通过单击数据库"文件夹上的加号来打开数据库

1. From object explorer, open databases by clicking the plus sign on Databases folder

1. 您将看到许多数据库.单击任何一个的加号.
2. 打开一个名为Tables的文件夹，您将在该数据库中看到数据表.
3. 在已选择数据库名称的情况下单击CTLR + N.
4. 查询编辑器将打开.键入SELECT * FROM TableName.您需要用要浏览的表的名称替换TableName.
5. 单击F5.这将在底部的网格中为您显示数据.
6. 右键单击所看到数据的左上角，然后单击带标题复制".
7. 转到Excel工作表并粘贴数据.

1. You will see many databases. Click the plus sign for any of them.
2. Open a folder called Tables, you will see the data tables in that database.
3. Click on CTLR + N with the database name selected.
4. A query editor will open. Type SELECT * FROM TableName. You need to replace TableName with the Name of the table you want to explore.
5. Click F5. This will display data for you in a grid at the bottom.
6. Right click on the top left of the data that you see and click on Copy with Header.
7. Go to an excel sheet and paste the data.

这是逐个表执行此操作的方法.但是，如果您想学习如何在Management Studio中操作数据，强烈建议您咨询数据库开发人员或具有数据库知识的同事. 此链接可能对您有帮助 http://www.w3schools.com/sql/sql_intro.asp

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

希望这会有所帮助.

这篇关于需要查看/转换.bak文件内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！