SQLCE Desktop Manager
今天从网友的评论中发现 SQLCE Desktop Manager 这个工具，可以实现在桌面电脑直接操作设备上的 SQL Server Compact 数据库。支持的操作包括创建数据库、设计表结构、编辑数据、执行SQL查询等。
SQLCE Desktop Manager v1.09 is available! This application will help you manage your SQL Server Compact Edition, Mobile Edition, SQL Server CE and SQLite 3 databases on Windows CE devices directly from desktop computer. With it you can create databases, design tables, edit data and run SQL queries. Current version supports:
- Microsoft SQL Server 2005 Compact Edition (SQL CE 3.1)
- Microsoft SQL Server 2005 Mobile Edition (SQL CE 3.0)
- Microsoft SQL Server 2000 CE Edition (SQL CE 2.0)
- SQLite 3 (Windows CE port, v3.3.5)
Main features of the SQLCE Desktop Manager are:
- run SQL queries on database
- create tables
- modify table design, change column types (even for existing tables, without loosing data!)
- manage keys and indexes
- rename tables and columns
- create, compact, password database
- generate SQL script for databases
- hex edit of binary data fields
- display query execution time
- view binary data fields as images
- export result sets to CSV
SQLCE Desktop Manager 的安装程序分为桌面客户端和设备Host端。从这点就可以猜到，它的原理是通过桌面端程序与设备端程序进行通信来实现各种操作的。就是桌面端程序发送操作指令到设备端程序，设备端程序解析指令并执行相应的操作。
