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: [email protected] [mailto:[email protected]] On Behalf Of padmini godavarthi Sent: Friday, 24 September 2010 2:07 PM To: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users --------------------------------------------------------------------- To report this email as spam, please forward to [email protected] --------------------------------------------------------------------- ************************************************************************* 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:[email protected] 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 ************************************************************************* _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
