Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

Moderators: martimiz, UncleCheese, Sean, biapar, Willr, Ingo, swaiba, simon_w

Multiple databases to one


Reply


2 Posts   357 Views

Avatar
cumquat

Community Member, 198 Posts

28 November 2011 at 10:02pm

Morning everyone,

Need a bit of help or a nudge in the right the direction. I manage a website for the Search and Rescue team i'm on and on this we list our callouts for the year. Well it now looks like that the national body wants to use a similar site and would like me to get all the team sites feeding their callouts data into one main callout list.

The main question is how do i do it :o)

Ok each site has it's own database and dataset i need to pull that data and display in one list, do i create a table on the main site that pulls the information on a scheduled basis or do i just run query's and merger the data at that point with no permanent table but could that end up being too slow. Also i'm not sure how to merge data or even for that matter getting a scheduled import of data into a table.

Any help pointers code greatly appreciated.

regards

Mick

Avatar
cumquat

Community Member, 198 Posts

30 November 2011 at 11:56pm

**bump** anyone?