如何在服务器上访问和同步本地数据库与数据库 [英] How to Access and sync Local Database with a database on server

问题描述

我创建了一个桌面应用程序，其数据库位于Web服务器上。但是应用程序变慢，因为开始表单有一些提取查询。这就是为什么应用程序在删除，保存，获取和从而失去桌面应用程序的味道方面变得缓慢的原因。
所以有任何方法可以使我可以使用本地mdf或sdf类型数据库进行任何操作像删除，获取和插入等对服务器数据库（在后台）的影响就像同步一样。请给我一个演示和示例源代码。

先生我不熟悉同步。你能帮我么。提前谢谢

I have created a desktop application whose database is on web server. But the application getting slow as the opening form have some fetching queries. That is why the application goes slow on deleting, saving, fetching and hence lost the flavour of desktop application.
So is there any way so that I can use a local mdf or sdf type database for any operation like delete,fetch,and insert etc. that effect on server database(in background) just like synchronisation. Please give me a demonstration and Example source code.
Sir I am not familiar with synchronisation. Can you Please help me. Thank you in advance

推荐答案

请阅读：十个常见的SQL编程错误 [ ^ ]。



我几乎可以肯定主要问题出在查询性能 [ ^ 。有增加查询执行时间的几种方法 [ ^ ]。



另一方面，它可能是lan-wan连接问题。你需要诊断它。



最后......

两个数据库之间的同步可以通过链接服务器 [ ^ ]。

如何创建链接服务器 [ ^ ]

Please, read this: Ten Common SQL Programming Mistakes[^] before you make a decision to use local database.

I'm almost sure that the main problem is in query performance[^]. There is few ways to increase query execution time[^].

On the other side, it could be the lan-wan connection problem. You need to diagnose it.

Finally...
Syncronization between two databases is possible via linked server[^].
How to Create a Linked Server[^]

这篇关于如何在服务器上访问和同步本地数据库与数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！