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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

DataObjectManager Module /

Discuss the DataObjectManager module, and the related ImageGallery module.

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

Multiple databases to one

Go to End

2 Posts   561 Views


Community Member, 201 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.




Community Member, 201 Posts

30 November 2011 at 11:56pm

**bump** anyone?