导出数据库结构 [英] exporting the database structure

问题描述

如何将数据库的结构(sql)导出到文本文件中.
我目前正在使用Microsoft SQL Server，因此，如果该程序可以实现，那将是最好的选择.

我需要这样做，因为必须将数据库(结构)导出到USB记忆棒，然后从那里导出到另一台服务器上.

我知道SQL Server附带有一个导出向导，但是，这不允许我导出到sql文本文件(或根本可用的东西).

在此先谢谢您.

How do i export the structure(sql) of a database into a text file.
I''m currently using Microsoft SQL server, so it would be best if it was possible with that program.

I''m in need for this becouse the database(structure) must be exported to an usb stick, and onto a different server from there.

I know that an export wizzard comes included with SQL server, however, this won''t let me export to an sql text file (or something usable at all).

Thanks in advance.

推荐答案

请检查以下链接(逐步信息):

Please check the following link (step by step info):

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]

这篇关于导出数据库结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！