blocks|key|4576388|text|我是红门公司的产品经理。我们有SQL+Comparison+SDK，它提供了对API的访问，您可以使用该API来比较两个模式并生成应用于目标的更改脚本。但是，如果需要将复杂的数据迁移作为更改的一部分，则这是有局限性的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4576389|我们正在努力在下一个版本中改进这一点。我们正在添加一个新功能，SQL+Migrations，它将允许您为“复杂”的更改指定您自己的自定义脚本。比较和同步工具SQL+Compare将与SQL源代码管理一起提供此功能。如果你感兴趣，这里有一个early+access+program。我们希望在2011年9月发布测试版。|4576390|entityMap|0|LINK|mutability|MUTABLE|url|https://www.red-gate.com/products/sql-development/sql-comparison-sdk/|1|http://www.red-gate.com/MessageBoard/viewtopic.php?t=12970^0|F|I|0|0|3B|K|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]]]]

I work as a product manager at Red Gate. We have the <a href="https://www.red-gate.com/products/sql-development/sql-comparison-sdk/" rel="nofollow">SQL Comparison SDK</a>, which provides access to an API that you can use to compare two schemas and generate a change script to apply to the target. However, this has limitations if complex data migrations are required as part of the change. 

We're working on improving this in the next release. We're adding a new feature, SQL Migrations, that will allow you to specify your own custom scripts for 'complex' changes. The comparison and synchronization tool, SQL Compare, will work in conjunction with SQL Source Control to provide this functionality. If you're interested, there's an <a href="http://www.red-gate.com/MessageBoard/viewtopic.php?t=12970" rel="nofollow">early access program</a>. We're hoping to get a beta release out in September 2011.

blocks|key|4576403|text|我发现了一个工具，它将为我从http://www.innovartis.co.uk/+DB+Ghost完成这项工作|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4576404|干杯|4576405|entityMap|0|LINK|mutability|MUTABLE|url|http://www.innovartis.co.uk/^0|E|S|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I found a tool that will do the work for me DB Ghost from <a href="http://www.innovartis.co.uk/" rel="nofollow">http://www.innovartis.co.uk/</a>

Cheers

blocks|key|3109113|text|没有100%25的解决方案...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3109114|但是根据我的经验，redgate的工具在这方面做得相当好--参见http://www.red-gate.com/products/sql-development/sql-developer-bundle/和esp。http://www.red-gate.com/products/sql-development/sql-packager/|offset|length|3109115|entityMap|0|LINK|mutability|MUTABLE|url|http://www.red-gate.com/products/sql-development/sql-developer-bundle/|1|http://www.red-gate.com/products/sql-development/sql-packager/^0|0|W|1Y|0|2Z|1Q|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]|$D|U|E|V|1|W]]|A|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]|N|$5|I|J|K|A|$L|O]]]]

there is no 100% solution out there...

Bute in my experience the tools from redgate are rather good at this - see <a href="http://www.red-gate.com/products/sql-development/sql-developer-bundle/" rel="nofollow noreferrer">http://www.red-gate.com/products/sql-development/sql-developer-bundle/</a> and esp. <a href="http://www.red-gate.com/products/sql-development/sql-packager/" rel="nofollow noreferrer">http://www.red-gate.com/products/sql-development/sql-packager/</a>

blocks|key|4576362|text|不是真的--不是开箱即用。最好、最灵活的方法是为数据库的所有更改创建更改脚本，然后将这些更改包含到常规部署中，然后自己运行，或者使用SSW+SQL+Deploy等工具(可以作为独立的命令行工具、独立的向导运行，也可以通过.NET界面从您的应用程序运行)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4576363|.NET实体框架团队已经启动了一项名为EF+Code-First+Migrations的计划，旨在简化这种数据库升级方案-这是非常新的，并且仍在进行中，但如果您在实体框架中使用代码优先的方法，它看起来很有前途。|4576364|entityMap|0|LINK|mutability|MUTABLE|url|http://www.ssw.com.au/ssw/SQLDeploy/|1|http://blogs.msdn.com/b/efdesign/archive/2010/10/22/code-first-database-evolution-aka-migrations.aspx^0|1U|E|0|0|J|O|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]]]]

Not really - not out of the box. The best and most flexible approach would be to create change scripts for all your changes to the database, and then include those into your regular deployment, and run them, either on your own, or using a tool such as <a href="http://www.ssw.com.au/ssw/SQLDeploy/" rel="nofollow">SSW SQL Deploy</a> (which can be run as a stand-alone command line tool, a stand-alone wizard, or from your app through a .NET interface).

The .NET Entity Framework team has started an initiative called <a href="http://blogs.msdn.com/b/efdesign/archive/2010/10/22/code-first-database-evolution-aka-migrations.aspx" rel="nofollow">EF Code-First Migrations</a> which aims at easing this database upgrade scenario - this is very new and very much still work in progress, but it looks quite promising, if you're using the code-first approach with Entity Framework.

blocks|key|991950|text|我们在政府部门，正在使用Kal+Admin，并且非常喜欢它。我们正在使用它进行变更管理，也就是版本控制和比较。我不确定，但我想它不贵。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|991951|entityMap|0|LINK|mutability|MUTABLE|url|http://www.kalromsystems.com/^0|C|9|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

We at a government ministry, are using <a href="http://www.KalromSystems.com" rel="nofollow">Kal Admin</a>, and like it a lot . 
We are using it for Change Management, source control aka version control and Compare. I am not sure but I think it's not expensive.

Does anybody know of a good change management tool for SQL Server? 

We would like to use it to migrate our existing clients database to newer version via an api.

SQL Server change management

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

有没有人知道针对SQL Server的好的变更管理工具？我们想使用它通过api将我们现有的客户数据库迁移到较新的版本。

问SQL Server变更管理
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server变更管理EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server变更管理
EN