如何将 sql 数据文件导入 SQL Server? [英] How do I import a sql data file into SQL Server?

问题描述

我有一个 .sql 文件，我正在尝试将其导入 SQL Server 2008.执行此操作的正确方法是什么?

I have a .sql file and I am trying to import it into SQL Server 2008. What is the proper way to do this?

推荐答案

如果你在谈论一个实际的数据库(一个 mdf 文件)，你会附加它

If you are talking about an actual database (an mdf file) you would Attach it

.sql 文件通常使用 SQL Server Management Studio 运行.它们基本上是保存的 SQL 语句，所以可以是任何东西.你不导入"它们.更准确地说，你执行"它们.即使脚本可能确实插入了数据.

.sql files are typically run using SQL Server Management Studio. They are basically saved SQL statements, so could be anything. You don't "import" them. More precisely, you "execute" them. Even though the script may indeed insert data.

此外，为了扩展 Jamie F 的答案，除非您知道它在做什么，否则不要针对您的数据库运行 SQL 文件.SQL 脚本可能和未经检查的 exe 一样危险

Also, to expand on Jamie F's answer, don't run a SQL file against your database unless you know what it is doing. SQL scripts can be as dangerous as unchecked exe's

这篇关于如何将 sql 数据文件导入 SQL Server?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！