I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db
.mdb) for every user now we made that to centralized database using SQL Server.
In the old application we have a
MasterDB.mdb which is in sync with the
local.mdb. Some times we need to sync with both the users of
local.mdb. After a particular interval of time we need to sync with the
We need to do this in SQL Server. So, I have a done more analysis related to SQL Server. I read a MSDN forums and many articles related to replication in SQL Server (Related Scenario). I think that merge replication matches to my requirements.
Can anyone suggest whether I have chosen the correct replication? Do we have any environment changes to set up this replication?