Abstract: In view of problem using file system to manage data existed in traditional EMS, the paper proposed a design scheme of CEMS database based on SQL Server CE. It gave hardward structure of CEMS, introduced application of embedded database SQL Server CE 2.0 in data management application program of CEMS under Windows CE 5.0 operating system platform in details. The result of simulation test showed that SQL Server CE 2.0 can provide effective and compact database solution for CEMS.