SQL存储过程/源安全/ Visual Studio [英] SQL Stored Procedures / Source Safe / Visual Studio

问题描述

使用Visual Studio 2003，您可以使用

Visual Source Safe来管理SQL存储过程。只要Visual Studio被用作编辑器，就可以在没有先检查存储过程的情况下对存储过程进行更改是不可能的。

out。一旦更改完成，就检查存储过程

返回Visual Source Safe。这个过程很有效。


但我看不出如何使用Visual Studio实现相同级别的控制

2005？我已经查看了VS数据库项目，但在更改存储过程之前我无法看到如何强制执行

检出，我看不出怎么样？ />
轻松查看所做的更改并确保已签入。


我错过了什么？

Using Visual Studio 2003 you were able to manage SQL stored procedures with
Visual Source Safe. So long as Visual Studio was used as the editor, it was
imposible to make a change to a stored procedure without first checking it
out. And once the changes were complete, the stored procedure was checked
back into Visual Source Safe. This process worked great.

But I can''t see how to achieve the same level of control using Visual Studio
2005? I''ve looked at the VS Database Project but I can''t see how to force a
check out prior to making a change to a stored procedure and I can''t see how
to easily see what changes have made and make sure they''re checked in.

Am I missing something?

推荐答案

您好Richard，


目前，在VS.NET 2005中，不支持存储过程版本控制。如果您需要将存储过程放入VSS，您可以尝试创建一个

数据库项目，将存储过程放在.sql文件中并检入

那个数据库项目。您可以查看以下主题以获取更多

有关如何在VS2005中签入数据库项目的信息。

http://groups.google.com/group/micro...safe/browse_th

read / thread / fea9f07c0cdb9c4c / ba58366e5402ba6f？lnk = st& q = alin + vs + 2005 + storage + p

rocedure& rnum = 2＃ba58366e5402ba6f

http://forums.microsoft.com/ MSDN / Sho ... 40739& SiteID = 1

Kevin Yu

微软在线社区支持


=============================================== === ==========================

============= =============

在回复帖子时，请回复群组通过你的新闻阅读器

其他人可以从你的问题中学习并从中受益。

==================== ============================== ==================== ======

==========================


（此帖子按原样提供，不作任何保证，并且不授予

权利。）

Hi Richard,

Currently, in VS.NET 2005, stored procedure versioning is not supported. If
you need to put the stored procedures into VSS, you can try to create a
database project, put the stored procedures in the .sql files and check in
that database project. You can check the following thread for more
information on how to check in database project in VS2005.

http://groups.google.com/group/micro...safe/browse_th
read/thread/fea9f07c0cdb9c4c/ba58366e5402ba6f?lnk=st&q=alin+vs+2005+stored+p
rocedure&rnum=2#ba58366e5402ba6f

http://forums.microsoft.com/MSDN/Sho...40739&SiteID=1

Kevin Yu
Microsoft Online Community Support

================================================== ==========================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==========================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

如果它无法在2003年完成可能的事情，那么2005年怎么能被认为是改进？


你能告诉我脚本数据库对象是怎样的吗？可以为这个问题提供一个实际的解决方案，因为我不能！


" Kevin Yu [MSFT]"写道：

How can 2005 be considered an improvement if it is incapable of doing the
things that were possible in 2003?

Can you demonstrate to me how scripting database objects can provide a
practical solution to this problem because I cana??t!

"Kevin Yu [MSFT]" wrote:

嗨理查德，

目前，在VS.NET 2005中，不支持存储过程版本控制。如果您需要将存储过程放入VSS，您可以尝试创建一个
数据库项目，将存储过程放在.sql文件中并检入该数据库项目。您可以查看以下主题以获取有关如何在VS2005中签入数据库项目的更多信息。

http://groups.google.com/group/micro...safe/browse_th
read / thread / fea9f07c0cdb9c4c / ba58366e5402ba6f？lnk = st& q = alin + vs + 2005 +存储+ p
rocedure& rnum = 2＃ba58366e5402ba6f
http://forums.microsoft.com/MSDN/Sho...40739&SiteID=1

Kevin Yu
微软在线社区支持

===================== ============================= ===================== =====
==========================
在回复帖子时，请回复群组 ;通过您的新闻阅读器，以便其他人可以从您的问题中学习并从中受益。
============================ ====================== ========================== /> ==========================

（此帖子按原样提供，不作任何保证，并且不授予
权利。）

Hi Richard,

Currently, in VS.NET 2005, stored procedure versioning is not supported. If
you need to put the stored procedures into VSS, you can try to create a
database project, put the stored procedures in the .sql files and check in
that database project. You can check the following thread for more
information on how to check in database project in VS2005.

http://groups.google.com/group/micro...safe/browse_th
read/thread/fea9f07c0cdb9c4c/ba58366e5402ba6f?lnk=st&q=alin+vs+2005+stored+p
rocedure&rnum=2#ba58366e5402ba6f

http://forums.microsoft.com/MSDN/Sho...40739&SiteID=1

Kevin Yu
Microsoft Online Community Support

================================================== ==========================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==========================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

嗨理查德，


这个是VS2005的休息变化。您可以在我上一篇文章中看到谷歌群组链接

，Alin是VSS团队的开发者。许多人与你的问题相同。

。作为支持工程师，我建议你把带有SQL脚本的数据库项目放到VSS上，这是目前唯一的解决方案

。


1.在SQL服务器中，编写整个数据库的脚本。

2.将脚本放到您创建的新数据库项目中。


我知道这有点复杂，但我正在努力提供我的工作方式。

有。


Kevin Yu

Microsoft在线社区支持


=============================== =================== ==========================

==========================

在回复帖子时，请回复群组通过你的新闻阅读器

其他人可以从你的问题中学习并从中受益。

==================== ============================== ==================== ======

==========================


（此帖子按原样提供，不作任何保证，并且不授予

权利。）

Hi Richard,

This is a break change in VS2005. You can see from the google groups link
in my last post, Alin is a develper in VSS team. Many people have had the
same issue as yours. As a support engineer, I can just suggest you to put
the database project with SQL scripts to VSS, this is the only solution
currently.

1. In SQL server, script the whole database.
2. Put the scripts to the new database project you have created.

I know it''s somewhat complex, but I''m trying to provide the workaround I
have.

Kevin Yu
Microsoft Online Community Support

================================================== ==========================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==========================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

这篇关于SQL存储过程/源安全/ Visual Studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！