应用需要复制 [英] Application needs replication

问题描述

嗨


我们有一个在服务器上运行的MS Access应用程序，但有些笔记本电脑需要该应用才能脱机工作。我们的解决方案是使用Access

复制，当笔记本电脑连接到网络时，它会自动同步数据（双向）。我们希望将应用程序重写为vb.net/sql

服务器。我的问题是如何在sql server中专门在vb.net前端的
上下文中进行复制，即我们看到的是什么类型的编码/配置？b $ b我们在看？ br />

谢谢


问候

Hi

We have an MS Access application which runs on the server but some laptop
users need the app to work offline. Our solution has been to use Access
replication which automatically syncs data (both ways) when laptop is
connected to the network. We are looking to rewrite the app to vb.net/sql
server. My question is how does replication work in sql server specially in
context of a vb.net front end i.e. what sort of coding/configuration we are
we looking at?

Thanks

Regards

推荐答案

那么你将会断开用户;您需要在计算机上安装SQL Server的本地

实例。然后，您可以使用SQL

Server 2005合并复制拓扑来执行您需要的操作。阅读它

at ..
http://technet.microsoft.com/en-us/s.../bb331775.aspx


谢谢！

-

Mohit K. Gupta

B.Sc. CS，Minor Japanese

MCTS：SQL Server 2005

" John"写道：

Well since you will have disconnected users; you will need to have a local
instance of the SQL Server installed on the computer. Then you can SQL
Server 2005 Merge Replication Topology to do what yaa needed. Read up on it
at ..
http://technet.microsoft.com/en-us/s.../bb331775.aspx

Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John" wrote:

嗨


我们有一个MS Access应用程序在服务器上运行，但有些笔记本电脑

用户需要该应用程序脱机工作。我们的解决方案是使用Access

复制，当笔记本电脑连接到网络时，它会自动同步数据（双向）。我们希望将应用程序重写为vb.net/sql

服务器。我的问题是如何在sql server中专门在vb.net前端的
上下文中进行复制，即我们看到的是什么类型的编码/配置？b $ b我们在看？ br $>

谢谢


问候

Hi

We have an MS Access application which runs on the server but some laptop
users need the app to work offline. Our solution has been to use Access
replication which automatically syncs data (both ways) when laptop is
connected to the network. We are looking to rewrite the app to vb.net/sql
server. My question is how does replication work in sql server specially in
context of a vb.net front end i.e. what sort of coding/configuration we are
we looking at?

Thanks

Regards

我有理由相信我需要编写代码，好像我的应用程序连接到相同的单个sql服务器和各种sql server安装程序会自动采取

关心他们自己之间的同步而不需要app干预笔记本电脑

是否已连接到网络？


谢谢


问候


Mohit K. Gupta < mo ********* @ msn.comwrote in message

news：D4 ********************* ************* @ microsof t.com ...

Am I right to believe I need to code as if my app is connected to the same
single sql server and various sql server installs would automatically take
care of the sync between themselves without intervention by app when laptops
are connected to the network?

Thanks

Regards

"Mohit K. Gupta" <mo*********@msn.comwrote in message
news:D4**********************************@microsof t.com...

好​​了，因为你将断开用户;您需要在计算机上安装SQL Server的本地

实例。然后，您可以使用SQL

Server 2005合并复制拓扑来执行您需要的操作。阅读



at ..
http://technet.microsoft.com/en-us/s.../bb331775.aspx


谢谢！

-

Mohit K. Gupta

B.Sc. CS，Minor Japanese

MCTS：SQL Server 2005


" John"写道：

Well since you will have disconnected users; you will need to have a local
instance of the SQL Server installed on the computer. Then you can SQL
Server 2005 Merge Replication Topology to do what yaa needed. Read up on
it
at ..
http://technet.microsoft.com/en-us/s.../bb331775.aspx

Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John" wrote:

>嗨

我们有一个MS Access应用程序在服务器上运行，但有些笔记本电脑用户需要应用程序脱机工作。我们的解决方案是使用Access
复制，当笔记本电脑连接到网络时，它会自动同步数据（双向）。我们希望将应用程序重写为vb.net/sql
服务器。我的问题是在vb.net前端的上下文中，复制如何在sql server中特别工作，即我们看到的是什么类型的编码/配置？

谢谢

>Hi

We have an MS Access application which runs on the server but some laptop
users need the app to work offline. Our solution has been to use Access
replication which automatically syncs data (both ways) when laptop is
connected to the network. We are looking to rewrite the app to vb.net/sql
server. My question is how does replication work in sql server specially
in
context of a vb.net front end i.e. what sort of coding/configuration we
are
we looking at?

Thanks

Regards

在一个感觉是的，但实际上没有。我的意思是，因为你将在每台笔记本电脑上安装一个本地安装的SQL Server;您可以将应用程序编码为

连接到localhost，开发人员无需编码即可连接

部件。但实际上;这些都是不同计算机上的SQL Server的不同实例，每个人都会有不同的名字。


我没有为复制环境编码，但很少面对开发人员正在处理合并冲突的挑战。可能发生三种情况：


1）记录已更新，但不再存在。

2）插入记录;并导致重复的主键。

3）在两个位置更新相同的记录，两者都有效但有冲突。


复制通常是定时事件;所以服务器在网络上，

本地服务器将与分销商和发布数据库进行通信

以根据需要更新信息。我希望这会给你一些想法。谢谢！


-

Mohit K. Gupta

B.Sc. CS，Minor Japanese

MCTS：SQL Server 2005

" John"写道：

In a sense yes, but actually no. What I mean is, since you will have a
local install of SQL Server on each laptop; you can code the application to
connect to localhost and no coding required for developer for connecting
parts. But in fact; these are all different instances of SQL Server on
different computer, everyone will have different names.

I haven''t coded for replication enviornment, but few challanges that face
you developers is handling merge conflicts. Three possible cases can happen:

1) Record is updated, but no longer exists.
2) Insert a record; and causes a duplicate primary key.
3) Updating same records in two locations, both valid but are in conflict.

Replication is usually timed event; so onces the server is on the network,
the local server will talk to the distributor and the publitioning database
to update information as needed. I hope this gives you some ideas. Thanks!

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John" wrote:

我是否正确相信我需要编码好像我的应用程序连接到相同的

单个sql服务器和各种sql当笔记本电脑连接到网络时，服务器安装会自动接受

关心他们自己之间的同步而无需干预吗？


谢谢


问候


" Mohit K. Gupta" < mo ********* @ msn.comwrote in message

news：D4 ********************* ************* @ microsof t.com ...

Am I right to believe I need to code as if my app is connected to the same
single sql server and various sql server installs would automatically take
care of the sync between themselves without intervention by app when laptops
are connected to the network?

Thanks

Regards

"Mohit K. Gupta" <mo*********@msn.comwrote in message
news:D4**********************************@microsof t.com...

好​​了，因为你将断开用户;您需要在计算机上安装SQL Server的本地

实例。然后，您可以使用SQL

Server 2005合并复制拓扑来执行您需要的操作。阅读



at ..
http://technet.microsoft.com/en-us/s.../bb331775.aspx


谢谢！

-

Mohit K. Gupta

B.Sc. CS，Minor Japanese

MCTS：SQL Server 2005

" John"写道：

Well since you will have disconnected users; you will need to have a local
instance of the SQL Server installed on the computer. Then you can SQL
Server 2005 Merge Replication Topology to do what yaa needed. Read up on
it
at ..
http://technet.microsoft.com/en-us/s.../bb331775.aspx

Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John" wrote:

嗨


我们有一个MS Access应用程序在服务器上运行，但有些笔记本电脑

用户需要该应用程序脱机工作。我们的解决方案是使用Access

复制，当笔记本电脑连接到网络时，它会自动同步数据（双向）。我们希望将应用程序重写为vb.net/sql

服务器。我的问题是如何在sql server中专门复制

在一个vb.net前端的
上下文中，即我们的编码/配置是什么类型$ b我们正在看$ b $


谢谢


问候

Hi

We have an MS Access application which runs on the server but some laptop
users need the app to work offline. Our solution has been to use Access
replication which automatically syncs data (both ways) when laptop is
connected to the network. We are looking to rewrite the app to vb.net/sql
server. My question is how does replication work in sql server specially
in
context of a vb.net front end i.e. what sort of coding/configuration we
are
we looking at?

Thanks

Regards

这篇关于应用需要复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！