Combining Multiple Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok people, I have a question that I hope someone can help me with. I am
building a system to handle Employee information; Purchasing, Estimating,
Project Management and Time Keeping. I have multiple databases, or will have,
because there will be jobsites that may not have internet or able to transfer
files to the main site. At the main site everyone's information is in one
central database and gets all the same reports, I just need to be able to get
the other jobsites (which will be more than one) into the same system. With
job sites that do not have a server, then they would have to go somewhere
where they can connect to our server then transfer that information to it.
This information must always be updated and accurate. I am just not sure how
to go about getting all the information in one central location to be able to
have accurate reporting.

I need to be able to have updated data changed and new data added without
deleting and overiting the data already in place. I maybe making this more
complicated than I think.

Should I just append everything together into a new table or database
everyday to have it work? I have many tables that I will need to do this to.

Thanks!
 
Check out Replication. It supports the data synchronization of multiple
back ends on a schedule or on-demand. It may not address all your problems,
but it is a "built-in" option.
 
Back
Top