我可以将子文件夹添加到SQL Server Management Studio项目吗？

What is the best way to keep large projects organized with SSMS?

使用SSMS保持大型项目组织的最佳方法是什么?

I want to do something like:

我想做的事情如下:

ProjectRoot
    SchemaObjects
        Tables
            Constraints
            Indexes
            Keys
        Functions
        Views
        Stored Procedures
     Scripts
         DataGeneration

And so on, but I cannot find a nice way to do this... Any suggestions?

等等,但我找不到一个很好的方法来做这个......有什么建议吗?

2 个解决方案

#1

I don't think there's anyway way to do this in SMSS, at least not in 2005. Maybe a third party tool will give you this; there's a list of replacements for 2000 Enterprise Manager here; not the most current, but probably a good starting point.

我不认为在SMSS中有任何方式可以做到这一点,至少在2005年没有。可能第三方工具会给你这个;这里有2000企业管理器的替换列表;不是最新的,但可能是一个很好的起点。

#2

Sadly there isn't. Maintain your object scripts out side of SSMS and simply edit them in SSMS.

可悲的是没有。将对象脚本保留在SSMS之外,并在SSMS中进行简单编辑。

IMHO this is one thing that is lacking big time in SSMS.

恕我直言,这是SSMS缺乏时间的一件事。

#1

#2