Split Database with Synchronization

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kevin McBrearty (KevinMcBrearty_at_discussions.microsoft.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 13:42:01 -0700

I am currently designing a database that will be used on a LAN and a number of remote laptops that may or may not have access to the internet.

I would like to be able to have a split database so that I can modify the front end without have to worry about bringing the data over to a new database. I already know how to accomplish this, I am just mentioning it to see if anyone can forsee any problems that I may have.

Now to get into Synchronization, I know how to accomplish this in a database that is not split by creating a replica. I don't know that I entirely like the way that it works but I can get it to work. The problem I am running into is when I split the database into two parts, and being able to syncronize the backend while using the frontend.

My other concern, Is this the best way to accomplish syncronizing the database with the situation that I have. I know I often design a database one way, to find out later that it would have worked better had I done it a different way. I am trying to avoid that realization on this database project.

Any help you could provide would be much appreciated. Thank you in advance for you time.

Relevant Pages

  • Re: Relational database & OO
    ... The RDB Data Model and the solution's Class Model will typically be different for non-CRUD/USER applications because they need to be optimized differently. ... all the business systems I've participated coding or designing spent little production time changing data. ... Given statistics like these it makes little sense to design your application or OO model before designing your database. ... And OO Class Models are routinely normalized as part of the basic paradigm methodology. ...
    (comp.object)
  • Re: Replication: Alternatives?
    ... > copy of the database. ... > cannot be connected to the LAN. ... If they can *never* be connected to the LAN, replication is ... single point of connection between the LAN and outside the LAN. ...
    (microsoft.public.access.replication)
  • Re: replacing a satellite node with another machine
    ... notices that "the LAN, not DECnet, is used" and calls ... %LANCP-E-DEVNFND, Device not found in LAN device database, device F ... %LANCP-E-CMDERROR, Error executing command ...
    (comp.os.vms)
  • Re: Very slow response
    ... If you open a new Access database, select Tools, Options ... ... has been set to something on the LAN? ... > I entered Access, open the database file ... > Then I enter the report's design view to edit the report layout ...
    (microsoft.public.access.reports)
  • Re: Writing a DAL with TDD
    ... will use the database - which is what you advocated elsewhere. ... designing some new algorithm for a particular business scenario. ... you'll say that we "just" mock those things... ... talented developers, coupled with the strongest ...
    (microsoft.public.dotnet.languages.csharp)