将整个 SQL 服务器数据库从服务器复制到本地 SQL Express 的最简单方法 [英] Easiest way to copy an entire SQL server Database from a server to local SQL Express

问题描述

我需要将整个数据库从服务器上的 SQL Server 2005 复制到本地 SQL Express，以便运行我的应用程序进行演示.完成这项工作的最快/最简单的方法是什么?

I need to copy an entire database from a SQL Server 2005 on my server over to my local SQL Express in order to run my application for a presentation. What is the fastest/easiest way to get this done?

我对我的服务器的访问非常有限，所以我认为我无法访问我可以创建的备份文件.

I have very limited access to my server so I don't think I can access the backup file that I could create so that is out.

推荐答案

如果数据库不是太大，可以使用数据库发布向导.

If the database is not too big, you could use the Database Publishing Wizard.

这是 Microsoft 提供的免费工具，可为您创建完整的数据库 SQL 脚本(不仅是表格和内容，还有所有数据).

This is a free tool from Microsoft which creates a complete SQL script of a database for you (not only the tables and stuff, but all data as well).

您可以在您的机器上安装该工具，连接到远程服务器并让该工具直接在您的机器上创建脚本.

You can install the tool on your machine, connect to a remote server and let the tool create the script directly on your machine.

您可以下载数据库发布向导 此处.

You can download the Database Publishing Wizard here.

显然上面的链接在 2019 年不再有效.
这可能是因为在较新版本的 SQL Server Management Studio 中，数据库发布向导的功能是开箱即用的，因此无需单独安装.

Apparently the link above doesn't work anymore in 2019.
That's probably because in newer versions of SQL Server Management Studio, the functionality of the Database Publishing Wizard is included out-of-the-box, so there's no need to install it separately.

现在称为 生成和发布脚本向导，但它的作用完全相同.

It's now called the Generate and Publish Scripts Wizard, but it does exactly the same.

这篇关于将整个 SQL 服务器数据库从服务器复制到本地 SQL Express 的最简单方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！