如何在Sqlce和Sql Server数据库之间合并 [英] How Do I Merge Between Sqlce And Sql Server Database

问题描述

亲爱的先生，我正在使用手持式Rfid Reader并使用sqlCe数据库，但在服务器或我的PC sql server dabase是有的，所以无论在sqlCe中发生的更新都必须在sqlserver中更新相同的数据....请帮助我我是新来的

解决方案

不要指望这是一个五分钟的工作：这是一个很大的主题，你必须非常非常仔细地考虑，并且可能需要对您的数据库以及软件工作进行重大更改。



这称为数据库复制，它是使数据库保持最新状态的过程当他们不一定在线或连接时。



从这里开始： http://technet.microsoft.com/en-us/library/ms171850(v = sql.105）.aspx [ ^ ]

但值得好好看看其中一些： Google [ ^ ]

dear sir i am using handheld Rfid Reader and using sqlCe database but in server or my PC sql server dabase is there so whatever the updations will happen in sqlCe the same data has to be updated in sqlserver.... please help me i am new to this

解决方案

Don't expect this to be a five minute job: this is a big subject which you have to think about very, very carefully, and may require significant changes to your database as well as software work.

It's called Database Replication, and it's the process of keeping databases up-to-date with each other when they aren't necessarily on line or connected all the time.

Start here: http://technet.microsoft.com/en-us/library/ms171850(v=sql.105).aspx[^]
But it's worth a good look at some of these as well: Google[^]

这篇关于如何在Sqlce和Sql Server数据库之间合并的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！