blocks|key|934532|text|哦，你用了一种痛苦的方式生成脚本。您应该已经为所有过程创建了一个脚本，方法是右键单击SSMS中的数据库，选择Tasks+->+Generate+Scripts。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|934533|但是，如果您不想再次经历该过程，请在文件夹中打开cmd+shell，并记住那些旧的批处理文件：|934534|for+%25f+in+(*.sql)+do+sqlcmd+-i+%25f|code-block|syntax|javascript|934535|这应该能起到作用！如果需要，您可以向sqlcmd添加其他参数(例如，登录、密码、服务器名称等)。要查看开关列表，只需执行sqlcmd+-h即可。|offset|length|style|CODE|934536|entityMap^0|0|0|0|1O|9|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@$K|U|L|V|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Oops, you did the painful way of generating scripts. You should have created a single script for all procedures by right clicking on the database in SSMS, choosing Tasks -> Generate Scripts.

However, if you don't want to go through that process again, open up a cmd shell in the folder and remember those old batch file days:

<pre><code>for %f in (*.sql) do sqlcmd -i %f
</code></pre>

This should do the trick!
You could add other parameters to sqlcmd if required (i.e. login, password, server name, ...). To see a list of switches just do a <code>sqlcmd -h</code>.

blocks|key|135268|text|对于SQL2K和2K5，您需要this+tool。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|135269|不久前，我问了一个类似的问题，并从Mike+L那里得到了这个建议(+got+votes+here)。|135270|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en|1|https://stackoverflow.com/questions/121837/sql-server-2005-importing-data-from-sql-server-2000^0|F|9|0|0|18|4|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

For SQL 2K &amp; 2K5, you want <a href="http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&amp;displaylang=en" rel="nofollow noreferrer">this tool</a>.

I asked a similar question awhile ago and got this advice from Mike L (give him votes <a href="https://stackoverflow.com/questions/121837/sql-server-2005-importing-data-from-sql-server-2000">here</a>).

blocks|key|934672|text|click+on+>右键单击要从中传输数据的数据库，然后选择Data+Transfer|type|unstyled|depth|inlineStyleRanges|entityRanges|data|934673|Select+Tables或|unordered-list-item|934674|+Procedure+(您想要传输数据的位置(在服务器、本地主机或任何文件上)|ordered-list-item|934675|934676|934677|934678|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|O|8|@]|9|@]|A|$]]|$1|H|3|-4|5|G|7|P|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|L|$]]

<ol>
<li>Right click on the database from where you want to transfer the data</li>
<li>Select Data Transfer</li>
<li>Select Tables or Store Procedure (what you want to transfer)</li>
<li>Select the location where you want to transfer the data (either on server or localhost or any file)</li>
</ol>

blocks|key|3352916|text|右键单击开发数据库，点击Generate+SQL+Scripts，然后只选择stored+precedures。如果你需要额外的过滤，你甚至可以选择你不需要的存储过程。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3352917|然后只需在开发时运行该查询。|3352918|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Right click on the development database Hit Generate SQL Scripts and then only select stored precedures. If you need need additional filtering you can even select the stored procedures you dont want.

Then just run that query on development.

blocks|key|135210|text|我不知道有没有一种命令行的方式来做到这一点，但是如果你把它们都放在文本文件中，那么编写一个快速而肮脏的应用程序应该不难，它只需循环所有文件，并使用您选择的任何语言在生产服务器上运行create语句。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|135211|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I don't know if there's a command line way to do it, but if you have them all in text files, it shouldn't be difficult at all to write a quick down and dirty app that just loops through all the files, and runs the create statements on your production server using whatever language you choose.

blocks|key|3353064|text|如果像我一样，你必须在一个文件夹的层次结构中处理一堆sql文件，这一行程序将把它们组合成一个名为out.sql的文件，你可以很容易地在SQL+Management+studio中执行它。它将只包含以.sql结尾的文件，并忽略*.sqlsettings等文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3353065|从.sql文件层次结构的根文件夹运行它。确保您在out.sql中没有任何有价值的东西，因为它将被替换。|3353066|del+out.sql+&&+for+/f+%25f+in+('dir+/b+/s+%5E%7C+findstr+/E+\.sql')+do+type+%25f+>>+out.sql|code-block|syntax|javascript|3353067|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If like me you have to deal with a bunch of sql files in a hierarchy of folders, this one liner will combine them into a single file called out.sql which you can easily execute in SQL Management studio. It will only include files that END in .sql, and ignore files such as *.sqlsettings.

Run it from the root folder of the hierarchy of .sql files. Be sure you have nothing of value in out.sql, as it will be replaced.

<pre><code>del out.sql &amp;&amp; for /f %f in ('dir /b /s ^| findstr /E \.sql') do type %f &gt;&gt; out.sql
</code></pre>

I restored my development database from production, and the stored procedures I need in my development environment doesn't exist in my production database. Is there a command Ii can use to import the developmetn stored procedures back into SQL Server. There are about 88 files, as each procedure is in a different text file.

TIA!
Chris

Import Existing Stored Procedures In SQL Server

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我从生产环境中恢复了开发数据库，而我的开发环境中需要的存储过程在我的生产数据库中不存在。是否有一个命令Ii可以用来将已开发的存储过程重新导入SQL Server。大约有88个文件，因为每个过程都在不同的文本文件中。蒂娅！克里斯

问导入SQL Server中的现有存储过程
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问导入SQL Server中的现有存储过程EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问导入SQL Server中的现有存储过程
EN