如何执行SQL同步? [英] How do I do a SQL Sync?

查看:108
本文介绍了如何执行SQL同步?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

你好

我有2台笔记本电脑,它们都有自己的SQL Express 2012数据库程序.但是我需要能够使用打开的选项在它们之间同步数据.我的意思是,例如,虽然一台笔记本电脑在世界的另一部分,但仍然能够同步.

我们没有要使用的Internet sql服务器.

我最初的想法是创建(不确定如何),例如创建一个.xml文件,然后将其通过互联网/邮件/投递箱/等发送到另一台PC,反之亦然.

同步需要能够发送新数据以及更新数据...不认为我们将需要删除任何数据.

到目前为止,该数据库是一个简单的Client Info数据库,但是一旦有了同步解决方案,它就会增长.

所以我的问题是,我可以使用C#或.Net中的什么?我看到了Microsoft Sync Framework,但并没有真正看到如何使用它. (反之亦然.发送.mdf签证的人除外)

或者,我可以使用.xml的哪些选项?

谢谢

Hello

I have 2 laptops with both their own SQL Express 2012 database programs. But I need to be able to sync data between them with open options. What I mean is that while one laptop is in anther part of the world for example, still to be able to sync.

We don''t have a internet sql server to use.

My initial though was to create (not sure how yet) for example a .xml with the data which could then be send via internet/mail/dropbox/etc to the other pc and visa versa.

The sync needs to be able to send new data, as well as update data... don''t think we will need to delete any data.

So far the database is a simple Client Info database, but will grow once I have a sync solution.

So my question, what is there in C# or .Net I could use? I saw the Microsoft Sync Framework, but don''t really see how to work with that. (Other that sending a .mdf visa versa)

Or, what options with .xml do I have?

Thanks

推荐答案

阅读数据SQL Express中的同步 [ ^ ]:可能会让您入门.
Read Data Synchronization in SQL Express[^]: might get you started.


这篇关于如何执行SQL同步?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆