[mapguide-users] How to Retrieve data in Multiple Databases

[VOLZ Mark (FN)]

Padmini,

Are the data source's exactly the same (table structure and schemes) in
each location?
Do you have a different MGE server at each location?
Are the web layouts going to be exactly the same?
Do you have a different MGE server in each location? i.e the users in
Washington connect to http://intranet/washington/mgeserver and the users
in Florida connect http://intranet/florida/mgeserver

If the answer is yes to all of the above questions you can simply
package your site from one server and the then import it at the other
sites.

Even if there are minor differences with data structure/connections this
would be the way I would do it as it would simply mean changing the
database name, scheme name, etc once and all the layers would update.

There are numerous variations on the above so if you could send through
some more details hopefully someone with come up with a more detailed
response.

Mark


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of padmini
godavarthi
Sent: Friday, 24 September 2010 2:07 PM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] How to Retrieve data in Multiple Databases


Hi,
i am using MGE 2010 with .net 3.5 and oracle 10g data base.

we have oracle data base at differenet servers (server1(contains
washington data),server2(contains california data),server3(contains
florida data)).i want to display the one of these data on the mapguide
viewer based on selection(suppose if i select  washington the washington
data must be appeared on the map from server1).similarly if i select
florida,florida data must be loaded on the map from server 2.and so
on..........

So for this i think we can't create packages.right?  i think we have to
connect to the database server dynamicallay from our application to
retrieve the spatial data and display it on internet.Please let me know
the solution.if i missing something please let me know.

Thanks in Advance.

Regards,
Padmini
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/How-to-Retrieve-data-in-Multiple-
Databases-tp5565503p5565503.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users









---------------------------------------------------------------------
To report this email as spam, please forward to spam at mailcontrol.com
---------------------------------------------------------------------

 
*************************************************************************
This e-mail (including any attachments) may contain confidential or
privileged information and is intended for the sole use of the person(s) to
whom it is addressed. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, please
notify the sender of the message or send an e-mail to
mailto:help.desk at ergon.com.au immediately, and delete all copies. Any
unauthorised review, use, alteration, disclosure or distribution of this
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
responsibility for the content of any e-mail sent by an employee which is of
a personal nature.

Ergon Energy Corporation Limited      ABN 50 087 646 062
*************************************************************************