entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/a8425563b0e1b113e09e84453109a0e9.png|imageAlt|blocks|key|atfl5|text|您可以通过SQL+Server+Management+Studio为文件生成脚本，以下是步骤：|unstyled|depth|inlineStyleRanges|entityRanges|bibss|右键单击要为其生成脚本的数据库(而不是表)，然后选择任务-生成脚本|360sm|接下来，选择所请求的一个或多个表、视图、存储过程等(从选择特定的数据库对象中)|62aq1|单击高级-选择要编写脚本的数据类型|atql3|单击下一步并完成|27gvh|MSDN生成脚本|dbkcs|在生成脚本时，有一个区域允许您编写脚本、约束、键等。从SQL+Server2008+R2开始，在脚本下有一个高级选项：|8v3ut|​|dudsl|f1v1j|?|atomic|offset|length|9o7nh|dni0k^0|0|0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|15|H|@]|I|@]|6|$]]|$B|J|D|K|2|F|G|16|H|@]|I|@]|6|$]]|$B|L|D|M|2|F|G|17|H|@]|I|@]|6|$]]|$B|N|D|O|2|F|G|18|H|@]|I|@]|6|$]]|$B|P|D|Q|2|F|G|19|H|@]|I|@]|6|$]]|$B|R|D|S|2|F|G|1A|H|@]|I|@]|6|$]]|$B|T|D|U|2|F|G|1B|H|@]|I|@]|6|$]]|$B|V|D|W|2|F|G|1C|H|@]|I|@]|6|$]]|$B|X|D|-4|2|F|G|1D|H|@]|I|@]|6|$]]|$B|Y|D|Z|2|10|G|1E|H|@]|I|@$11|1F|12|1G|B|1H]]|6|$]]|$B|13|D|-4|2|F|G|1I|H|@]|I|@]|6|$]]|$B|14|D|W|2|F|G|1J|H|@]|I|@]|6|$]]]]

You can generate scripts to a file via SQL Server Management Studio, here are the steps:

<ol>
<li>Right click the database you want to generate scripts for (not the table) and select tasks - generate scripts</li>
<li>Next, select the requested table/tables, views, stored procedures, etc (from select specific database objects)</li>
<li>Click advanced - select the types of data to script </li>
<li>Click Next and finish</li>
</ol>

<a href="http://msdn.microsoft.com/en-us/library/hh245282.aspx" rel="noreferrer">MSDN Generate Scripts</a>

When generating the scripts, there is an area that will allow you to script, constraints, keys, etc. From SQL Server 2008 R2 there is an Advanced Option under scripting:

<img src="https://i.stack.imgur.com/bwmdz.png" alt="enter image description here">

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/bf81f8f1c759ecc1ff0c7804cc49dd6c.png|imageAlt|blocks|key|75k50|text|​|unstyled|depth|inlineStyleRanges|entityRanges|cui8k|bkjru|?|atomic|offset|length|ev8r4|e4bc6|ddjdf|在图中你可以看到。在“设置脚本选项”中，在右侧选择最后一个选项:要编写脚本的数据类型，然后选择所需内容。这是导出方案和数据时应选择的选项^0|0|0|0|1|0|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|T|H|@]|I|@]|6|$]]|$B|J|D|-4|2|F|G|U|H|@]|I|@]|6|$]]|$B|K|D|L|2|M|G|V|H|@]|I|@$N|W|O|X|B|Y]]|6|$]]|$B|P|D|-4|2|F|G|Z|H|@]|I|@]|6|$]]|$B|Q|D|E|2|F|G|10|H|@]|I|@]|6|$]]|$B|R|D|S|2|F|G|11|H|@]|I|@]|6|$]]]]

<img src="https://i.stack.imgur.com/K4NKP.png" alt="enter image description here">

In the picture you can see. In the set script options, choose the last option: Types of data to script you click at the right side and you choose what you want.
This is the option you should choose to export a schema and data

entityMap|blocks|key|avgo5|text|你有没有试过|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1hb28|(右键单击，任务，生成脚本)选项？这会产生你所说的"SQL文件“吗？^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

Have you tried the <code>Generate Scripts</code> (Right click, tasks, generate scripts) option in SQL Management Studio? Does that produce what you mean by a "SQL File"?

Is it possible in <code>MS SQL Server 2008</code> to export database structure into a <code>T-SQL</code> file? 

I want to export not only tables schema but also primary keys, foreign keys, constraints, indexes, stored procedures, user defined types/functions. 

Also I don't want the data to be present in this <code>T-SQL</code> file. 

Is there any way to achieve that?

Export database schema into SQL file

SQL Server

数据库

 有没有可能在 将数据库结构导出到 文件？ 我不仅要导出表模式，还要导出主键、外键、约束、索引、存储过程、用户定义的类型/函数。 另外，我不希望数据出现在这里 文件。 有什么方法可以做到这一点吗？

问将数据库架构导出到SQL文件
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将数据库架构导出到SQL文件EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将数据库架构导出到SQL文件
EN