SQL Server CE .sdf合并 [英] SQL Server CE .sdf merge

问题描述

我的应用程序在Windows CE 6.0上运行，它使用SQL Server CE .sdf 文件存储用户数据.该应用程序在未连接到Internet的工业设备上运行.升级软件的唯一方法是在其中插入USB记忆棒.

My application is running on Windows CE 6.0, and it uses a SQL Server CE .sdf file to store user data. The application is running on an industrial device, which is not connected to internet. The only way to update the software is to plug a USB stick inside.

正如预期的那样，该应用程序的第一个发行版1.0现在需要更新到1.1，数据库架构也是如此.

As expected, the first release 1.0 of the application needs to update to 1.1 now, the database schema as well.

我如何合并具有最新1.1数据库模式的设备上的.sdf版本1.0，该版本可通过设备的文件系统(USB记忆棒)获得.

How could I merge the .sdf version 1.0 which is on the device with the latest 1.1 database schema that will be available through the File System (USB stick) of the device.

我在下面添加了一张图片，以帮助理解我的问题.

I added a picture below to help understanding my question.

我知道RDA和合并复制的可能性，但是我的应用程序未通过http连接到中央服务器.在学习如何使用它们之前，我需要专家的建议.

I am aware about RDA and Merge Replication possibility, but my application is not connecting to a central server through http. Before learning how to use them I would like an expert advice.

推荐答案

您将需要以编程方式应用将模式从1.0更改为1.1所需的更改.您可以通过使用ALTER TABLE/CREATE TABLE语句，并通过查询INFORMATION_SCHEMA视图来检查当前模式来实现此目的

You will need to programatically apply the changes required for the schema to change from 1.0 to 1.1. You can do this by using ALTER TABLE/CREATE TABLE statements, combined with inspecting the current schema by querying the INFORMATION_SCHEMA views

这篇关于SQL Server CE .sdf合并的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！