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've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

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   681 Views

Avatar
cumquat

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.

regards

Mick

Avatar
cumquat

Community Member, 201 Posts

30 November 2011 at 11:56pm

**bump** anyone?