Stored Procedure Service

Question

In sql server ...

Do I have to support stored procedures through the object browser in the query analyzer or as external text files and why?

Answer 1

... another vote for text files in the source control.

• A huge advantage is the history of change. Comparison of versions can give you an idea of ​​the problems and save hours of debugging, especially the fact that "I wonder why they did it." Diversity.
• , , , , , , , .
• . , Ant , .
• , . .
• , . GUI , , script.

Answer 2

, . , , .

Microsoft Visual Studio 2008 Database Edition , , , .

Answer 3

SQL Server SQL.

, SQL Server 2005+ SQL Server Management Studio, .NET Framework.

, , .

, , - SourseSafe .

Answer 4

, ( ). , , , , - , .

Answer 5

, .

, . , , , . - , ( , ), " ".

Answer 6

.

, "" . , .

If you have strong production management tools, good processes, and a code decomposition tool, then management in the object browser is possible for small projects, because you can always easily detect differences and reset.

I hope you do not mean objects in the browser during production ...