Carlos Benkendorf schrieb: > Hello, > > Currently our company has a lot of small stores distributed around the > country and in the actual database configuration we have a central > database and all the small stores accessing it remotely. > Hello Carlos, There is a number of replication solution available. To give you a better answer, here are some question to have a more precise view on your problem: how many tables and stores do you have? How is your application developed, technology etc.. What is the size of the tables and how many entries do change every day. -- Best Regards / Viele Grüße Sebastian Hennebrueder ---- http://www.laliluna.de * Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB * Seminars and Education at very fair prices. * Get professional support and consulting for these technologies. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend