blocks|key|757609|text|如果您愿意下载SQL+Anywhere版本11并对其进行比较，请查看此处所示的比较技术：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|757610|http://sqlanywhere.blogspot.com/2008/08/comparing-database-schemas.html|offset|length|757611|您不必升级SQL+Anywhere版本10数据库。|757612|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1Z|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

If you are willing to download SQL Anywhere Version 11, and Compare It!, check out the comparison technique shown here:

<a href="http://sqlanywhere.blogspot.com/2008/08/comparing-database-schemas.html" rel="nofollow noreferrer">http://sqlanywhere.blogspot.com/2008/08/comparing-database-schemas.html</a>

You don't have to upgrade your SQL Anywhere Version 10 database.

blocks|key|757628|text|这个街区的新成员是Qwerybuilder。它支持SQL+Server、Sybase+ASE、Sybase+SQL+Anywhere和Oracle。我已经成功地在SQL+Anywhere中使用它来跟踪模式更改。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|757629|entityMap|0|LINK|mutability|MUTABLE|url|http://www.werysoft.com/Features.aspx^0|9|C|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]]]]

The new kid on the block is <a href="http://www.werysoft.com/Features.aspx" rel="nofollow noreferrer">Qwerybuilder</a>. It supports SQL Server, Sybase ASE, Sybase SQL Anywhere and Oracle. I've used it successfully with SQL Anywhere to track schema changes.

blocks|key|760466|text|我遇到的两个支持SQL+Anywhere的工具：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|760467|上行场景数据库工作台-+http://www.upscene.com/products.dbw.sqlanywhere.php|offset|length|760468|Aquafold+-+http://www.aquafold.com/index-sybaseany.html|760469|每一个都有一个模式比较工具，但是我没有使用它们来比较模式。|760470|entityMap|0|LINK|mutability|MUTABLE|url|http://www.upscene.com/products.dbw.sqlanywhere.php|1|http://www.aquafold.com/index-sybaseany.html^0|0|C|1F|0|0|B|18|1|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@$D|Z|E|10|1|11]]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]]]

Two I've come across that support SQL Anywhere:

Upscene Database Workbench - <a href="http://www.upscene.com/products.dbw.sqlanywhere.php" rel="nofollow noreferrer">http://www.upscene.com/products.dbw.sqlanywhere.php</a>

Aquafold - <a href="http://www.aquafold.com/index-sybaseany.html" rel="nofollow noreferrer">http://www.aquafold.com/index-sybaseany.html</a>

Each one appears has a schema comparison tool, however I have not used either to compare schemas.

blocks|key|3008799|text|SQLDelta太棒了。它适用于SQL+Server。我在SQL2000和2005中使用过它。它将比较存储过程、表、视图、权限、索引等。我相信它还可以比较表之间的数据。您可以同步更改或生成SQL脚本以供以后使用。我经常使用它来编写从开发到生产的数据库更改脚本。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3008800|Ah...missed+Sybase备注。不确定SQLDelta是否能与it..but对话，我可能会试一试，因为Sybase很相似。|3008801|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqldelta.com/^0|0|8|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]]]]

<a href="http://www.sqldelta.com/" rel="nofollow noreferrer">SQLDelta</a> is awesome. It is for SQL Server. I've used it with SQL 2000 and 2005. It will compare stored procedures, tables, views, permissions, indexes, etc. It can also compare data between tables I believe. You can sync the changes or generate SQL Scripts for later use. I use it often to script out db changes in development to production.

Ah...missed the Sybase remark. Not sure if SQLDelta can talk to it..but I'd probably give it a shot since Sybase is similar.

blocks|key|5264248|text|尝试erwin+(CA+AllFusion+ERwin数据建模器)。它支持相当多的不同数据库，包括SQL+Anywhere，并且在反向/正向工程和模式比较方面相当好。然而，你可能会发现它太复杂了，不能用于比较……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5264249|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|$]]

Try erwin (CA AllFusion ERwin Data Modeler). It supports quite a lot of different DBs, including SQL Anywhere, and is quite good in reverse/forward engineering and schema comparison. However, you may find it a bit too complex to use for the comparison...

blocks|key|3853286|text|我使用Red+Gate的SQL+Data+Compare和SQL+Compare，data+compare允许您比较两个数据库的内容，并自动同步您的数据。SQL+compare允许您对数据库表执行相同的操作。每一个都有很好的图形用户界面，而且设置也很简单。它们还可以在远程数据库上工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3853287|那里不便宜，但每个都有30条路线，所以无论你喜欢与否，你都可以感受一下。|3853288|entityMap|0|LINK|mutability|MUTABLE|url|http://www.red-gate.com/products/SQL_Data_Compare/index.htm|1|http://www.red-gate.com/products/SQL_Compare/index.htm^0|C|G|0|T|B|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|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 use <a href="http://www.red-gate.com/products/SQL_Data_Compare/index.htm" rel="nofollow noreferrer">SQL Data Compare</a> from Red Gate along with <a href="http://www.red-gate.com/products/SQL_Compare/index.htm" rel="nofollow noreferrer">SQL Compare</a> the data compare allows you to Compare the contents of two databases and Automatically synchronize your data.
SQL compare allows you to do the same but with the database tables. Nice GUI on each and very easy setup. they also work on a remote database. 

There not cheap but each has a 30 trail so you can get a feel if you like it or not.

blocks|key|5264424|text|Sybase+PowerDesigner还可以比较或合并您的数据库架构。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5264425|它还可以通过ODBC从各种数据库加载Schema，如果您有Schema生成脚本，还可以将它们加载到模型中。|5264426|它是一个昂贵的工具，但对记录和开发您的模式更改非常有用。|5264427|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Sybase PowerDesigner can also Compare or Merge your Database Schema. 

It can also Load the Schema from various Databases by ODBC if you have Schema generation Scripts you can also load them into a Model.

Its an expensive tool but great to document and develop you schema changes IMHO.

blocks|key|3853543|text|布雷克·卡特的想法很好。为了快速扫描，我有一个旧产品，叫做DBDelta。我将其安装在一台旧的Windows2000计算机上，因为我的安装在XP计算机上不起作用。这是一个非常小的应用程序，可以通过ODBC连接比较两个SQL+Anywhere数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3853544|我已经做了一些搜索，试图找到较新的副本，但未能找到。开发者是查尔斯·布彻。我认为他支持了一段时间，然后在2002年左右停止了。|3853545|我会继续寻找链接。如果我发现了什么，我会把它贴在这里。|3853546|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

Breck Carter's idea is a good one. For quick scans, I have an old product that is called DBDelta. I have it installed on an old Windows 2000 machine because the install I have will not work on an XP machine. It's a very small app that compares two SQL Anywhere databases across an ODBC connection.

I've done some searches to try and find a later copy, but have not been able to. The developer was Charles Butcher. I think he supported it for a while and then stopped back in 2002 or so.

I'll continue to look for a link. If I find something I will post it here.

blocks|key|3853583|text|QweryBuilder+5.5.0将允许您一次性比较所有过程、函数、视图、表和触发器。此版本计划于2010年5月中旬发布。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3853584|它还没有完成，但我们还在考虑添加一个选项，将diff结果转换为可以在目标数据库上执行的脚本。|3853585|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|$]]

QweryBuilder 5.5.0 will allow you to compare all procedures, functions, views, tables and triggers in one shot. This release is scheduled for mid May, 2010.

It hasn't been finalized yet but we are also looking at adding an option to turn the diff results into a script that can be executed on a target database.

Are there any good database schema comparison tools out there that support Sybase SQL Anywhere version 10? I've seen a litany of them for SQL Server, a few for MySQL and Oracle, but nothing that supports SQL Anywhere correctly. 

I tried using DB Solo, but it turned all my non-unique indexes into unique ones, and I didn't see any options to change that.

Any good SQL Anywhere database schema comparison tools?

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

有没有好的支持Sybase SQL Anywhere版本10的数据库模式比较工具？我已经看到了一长串针对SQL Server的请求，还有一些针对MySQL和Oracle的请求，但没有一种能够正确支持SQL Anywhere。我尝试使用DB Solo，但它将我所有的非唯一索引转换为唯一索引，并且我看不到任何可以更改这一点的选项。

问有没有好的SQL Anywhere数据库模式比较工具？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有没有好的SQL Anywhere数据库模式比较工具？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有没有好的SQL Anywhere数据库模式比较工具？
EN