如何生成将使用数据重建 MS SQL Server 2005 数据库的脚本? [英] How do I generate scripts that will rebuild my MS SQL Server 2005 database with data?

问题描述

我有一个 SQL Server 2005 数据库，我希望能够立即重新创建.我希望能够指向我的数据库并生成一组完整的脚本，这些脚本不仅会创建数据库中的所有表/视图/sprocs/函数，而且还会填充所有带有数据的表格.

I have a SQL Server 2005 database, that I would like to be able to recreate at a moment's notice. I want to be able to point to my database and generate a complete set of scripts that will not only create all the tables / views / sprocs / functions that are in the database, but will also populate all the tables with data.

是否有任何工具可以做到这一点?是否有任何开源或免费工具可以做到这一点?

Are there any tools that do this? Are there any open-source or free tools that do this?

推荐答案

数据库发布向导 是一个很好的小工具.它的OSS和免费，很难被击败.

The Database Publishing Wizard is a great little tool for this. Its OSS and free, which is hard to beat.

这篇关于如何生成将使用数据重建 MS SQL Server 2005 数据库的脚本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！