Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

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 MasterDB.mdb.

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?

share|improve this question
Just to be clear, what is the strategy to migrate from Access to SQL Server? Separate databases, I assume? The topology of your system isn't clear from the question text. – Jon Seigel Mar 11 at 14:38
Client wants to migrate the DB part to SQL Server also. So he wants to do the replication process in SQL Server also . – Jai Ganesh Mar 12 at 5:16
That's my question. Is there actually a need/requirement to use replication, instead of a single database across the entire application? – Jon Seigel Mar 12 at 13:51

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.