blocks|key|4518712|text|你试过starinix的SQL+Compare吗？他们说它支持SQL+Server+(所有版本)，因此可能包括压缩版。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4518713|这个软件和我用过的一样工作(育空)。它也是免费软件，省去了对许可的担忧。|4518714|entityMap|0|LINK|mutability|MUTABLE|url|http://www.starinix.com/sqlcompare02.htm^0|C|B|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]]]]

Have you tried <a href="http://www.starinix.com/sqlcompare02.htm" rel="nofollow noreferrer">SQL Compare</a> from starinix? They say it supports SQL Server (All Editions) so that may include compact edition. 

This software does work as I have used it (for Yukon). It's also freeware which saves worrying about licensing.

blocks|key|3673332|text|最后，我使用Data+Port+Console将我的两个SQL+Server+Compact数据库导出到SQL+Server+Express+2005+(虽然2008也可以)，从而解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3673333|然后我使用Red+Gate+SQL+Data+Compare对它们进行了比较。|3673334|这个解决方案对我来说很好。|3673335|entityMap|0|LINK|mutability|MUTABLE|url|http://www.primeworks-mobile.com/Products/DataPortConsole.html|1|http://www.red-gate.com/products/SQL_Data_Compare/index.htm^0|6|H|0|0|5|P|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

In the end I solved this problem by Exporting my 2 SQL Server Compact Databases to SQL Server Express 2005 (although 2008 would work) using <a href="http://www.primeworks-mobile.com/Products/DataPortConsole.html" rel="nofollow noreferrer">Data Port Console</a>.

I then compared them using <a href="http://www.red-gate.com/products/SQL_Data_Compare/index.htm" rel="nofollow noreferrer">Red Gate SQL Data Compare</a>.

This solution works just fine for me.

blocks|key|3673371|text|不确定，但您也可以看看Apex+SQL工具-+Apex+SQL+Diff和Apex+SQL+DataDiff。那里的网站是here。他们没有特别提到SQL+Server+Compact+-但我相信你可以向他们询问。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3673372|Red-Gate和Apex是我对任何SQL工具的首选:-)|3673373|Marc|3673374|entityMap|0|LINK|mutability|MUTABLE|url|http://www.apexsql.com/sql_tools_diff.asp^0|1P|4|0|0|0|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|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

Not sure, but you could also have a look at the Apex SQL tools - Apex SQL Diff and Apex SQL DataDiff. There website is <a href="http://www.apexsql.com/sql_tools_diff.asp" rel="nofollow noreferrer">here</a>. They don't specifically mention SQL Server Compact - but I'm sure you could inquire with them.

Red-Gate and Apex are my #1 choices for any kind of SQL tools :-)

Marc

blocks|key|3673436|text|对我来说，下面的过程是可行的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3673437|3673438|安装SQL+Server+Compact+Toolbox扩展。|ordered-list-item|offset|length|3673439|3673440|3673441|在|3673442|的两个数据库上运行"Script+database+schema++data“命令|3673443|3673444|对生成的文件使用比较工具查看更改。|3673445|3673446|📷|atomic|3673447|entityMap|0|LINK|mutability|MUTABLE|url|http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/2861864dc3dc0a068137d30db84410f7.png|imageAlt^0|0|0|6|M|0|0|0|0|0|0|0|0|0|0|1|1|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1A|8|@]|9|@$F|1B|G|1C|1|1D]]|A|$]]|$1|H|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|1G|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1H|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|O|3|P|5|E|7|1J|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|1L|8|@]|9|@$F|1M|G|1N|1|1O]]|A|$]]|$1|U|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]|12|$5|13|Y|14|A|$15|16|17|-4]]]]

For me the following process worked:
<ol>
<li>Install SQL <a href="http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/" rel="nofollow noreferrer">Server Compact Toolbox</a> extension.
</li>
<li>Run the &quot;Script database schema and data&quot; command on both databases
</li>
<li>Use a diff tool on generated files to see the changes.
<img src="https://i.stack.imgur.com/RUTui.png" alt="List item" />
</li>
</ol>

Does anyone know of a tool similiar to RedGate's SQL Data Compare that works with Microsoft SQL Server Compact 3.5?

SQL data comparison tool for SQL Server Compact

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

有没有人知道类似于RedGate的SQL数据比较的工具，可以在Microsoft SQL Server Compact 3.5上运行？

问SQL Server Compact的SQL数据比较工具
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server Compact的SQL数据比较工具EN