MS Sync Framework的两个SQL Express [英] MS Sync Framework two sql express

问题描述

我有一个Windows Forms应用程序.
该数据库是MSSQL Express.
脱机缓存不应为SQL Compact.

我的问题:
是否可以在本地和SQL Server Express上使用以自动同步此操作.

我的应用程序需要DocumentID和CustomerID.它们必须是连续的，并且只能由主数据库发布.

我使用GUID作为PK.

我很失望，请帮我

I have a Windows Forms application.
The database is a MSSQL Express.
The offline cache should be no SQL Compact.

My question:
Is it possible to use locally and on a SQL Server Express, to syncronize this automatically.

My application requires DocumentID''s and CustomerID''s. These must be consecutive and may only be issued by the main database.

I work with a GUID as PK.

I despair of, please help me

推荐答案

否.没有自动的处理方法.
如果您不想使用紧凑型数据库，则可以使用Dictionary对象或Hashtable在本地存储此数据，但是无法自行更新.您需要重新启动应用程序以加载新数据.

我相信您没有太多数据，因为您正在使用SQL Express作为db.您还可以使用XML文件来保留ID，并使用单独的Windows服务来更新ID.这一切都取决于您希望它有多高效.

希望对您有所帮助.

No..there is no automatic way of handling it.
If you do not want to use compact db, you can use Dictionary object or a Hashtable to store this data locally but it can not get updated on it''s own. You need to re-start the application to load the fresh data.

I believe you do not have much data as you are using SQL express as db. You can use XML file as well to keep the ID''s and keep them updated using a separate windows service. It all depends how efficient you want it to be.

Hope it helps..

您好，
感谢您的快速回复.
现在，我已经可以将主数据库和语言环境同步到SyncOrchestrator.
但是，仍然存在一些未解决的问题.

如何仅从一条记录开始同步?我创建了一篇新文章，并希望立即保存.如果开始同步，则需要很长时间.
如何获得对主数据库的更改?更新后会通知我所有客户该怎么办?我可以在数据库上放置一些东西作为数据库触发器，以便在每次分发时插入记录吗?

Hello,
Thank you for your quick response.
I''ve done it now I can sync to a SyncOrchestrator the main database and the locale.
However, there are still some open questions.

How do I initiate a sync from only one record? I create a new article and want to save it now. If I start a synchronization, which takes a long time.
How do I get with changes to the main database? What should I do with all clients will be informed after an update? Can I put something on the DB as a database trigger to insert the records each time distributed?

这篇关于MS Sync Framework的两个SQL Express的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！