SQL Server是否与Oracle DBMS_METADATA.GET_DDL并行? [英] SQL Server parallels to Oracle DBMS_METADATA.GET_DDL?

问题描述

我正在寻找用于所有数据库对象(表，存储的proc，视图，索引/索引，约束等)的DDL退出SQL Server 2005+的命令行或脚本解决方案.

I'm looking for command line or scripted solutions to pull the DDL out of SQL Server 2005+ for all database objects: tables, stored procs, views, indices/indexes, constraints, etc. GUI tools are not of interest.

首选项是针对内置工具的，因为它与Oracle的DBMS_METADATA东西具有最高的可比性.另外，更喜欢像Oracle一样简单的解决方案，用于淘汰DDL-例如，一个班轮:

Preference is for built-in tools, since that would be the most comparable to Oracle's DBMS_METADATA stuff. Also, preference for a solution that is as simple as Oracle's for getting the DDL out - eg, a one liner:

    SELECT DBMS_METADATA.GET_DDL('TABLE', 'MY_TABLE') FROM DUAL

注意:在SQL Server 2005中为过程弄清楚事情似乎很容易，但是我找不到对其他对象(例如表)类似的引用.

Note: Getting things out for procedures in SQL Server 2005 seems easy, but I can't find any references to something similar for other objects (like tables).

    SELECT definition 
    FROM Sys.sql_modules 
    WHERE object_id = OBJECT_ID('MyProc')

提前谢谢！

推荐答案

Transact-SQL语言不支持.客户端库(SMO)可以使用 Scripter 对象，请参见 http://msdn.microsoft .com/en-us/library/ms162153.aspx .您可以将PowerShell中的SMO用作脚本解决方案.

There is no support in the Transact-SQL language. The client libraries (SMO) can do it using a Scripter object, see example at http://msdn.microsoft.com/en-us/library/ms162153.aspx. You can use SMO from PowerShell as a scripted solution.

SQL Management Studio还具有一个选项(右键单击数据库，转到任务"，选择生成脚本")，它在幕后使用了SMO Scripter.

The SQL Management Studio also has an option (right click on a database, go to Tasks, select Generate Scripts), it uses an SMO Scripter under the covers.

这篇关于SQL Server是否与Oracle DBMS_METADATA.GET_DDL并行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！