[DB-SIG] Mirroring DBs with Python
Timothy Wilson
wilson@visi.com
Fri, 7 Jul 2000 16:29:18 -0500 (CDT)
- Previous message: [DB-SIG] The Western Web has just finished our new classified ad section. Please check it out and make sure that your classified ad has been moved. We are in the process of moving ads at this time, but would appreciate your help to insure that if your ad has been moved. If it hasn't been moved or you would like to place a new ad feel free to do so. We have added new sections in the classifieds, hay/feed/shavings, livestock, camelids, cattle, deer and elk, poultry, rabbits, sheep, livestock equipment, swine, donkeys, dogs and mules. We are currently receiving 100 new ads a day, and over 20,000 unique hits a day.
- Next message: [DB-SIG] Mirroring DBs with Python
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
Hi everyone,
I'm interested is putting Python to work at my school doing what would seem
to be a relatively straight-forward task. I'd appreciate it if someone would
comment on the feasiblity of this or the best general approach.
Let's assume I've got Oracle running on Solaris at a remote site, accessible
via the Internet. The database is made of many tables with data referring to
many different schools. I'd like to do a query on that remote database,
pulling out the data that refers to my school only, and mirror the results
to a local DB running on Linux while maintaining the exact same table
structure. The local DB would likely be PostgreSQL or MySQL. (The overall
goal is to make that data accessible via Zope.) That local DB could be
read-only.
Does this sound reasonable?
Would it make a difference if Oracle was on NT instead of Solaris?
-Tim
--
Tim Wilson | Visit Sibley online: | Check out:
Henry Sibley HS | http://www.isd197.k12.mn.us/ | http://www.zope.org/
W. St. Paul, MN | | http://slashdot.org/
wilson@visi.com | <dtml-var pithy_quote> | http://linux.com/
- Previous message: [DB-SIG] The Western Web has just finished our new classified ad section. Please check it out and make sure that your classified ad has been moved. We are in the process of moving ads at this time, but would appreciate your help to insure that if your ad has been moved. If it hasn't been moved or you would like to place a new ad feel free to do so. We have added new sections in the classifieds, hay/feed/shavings, livestock, camelids, cattle, deer and elk, poultry, rabbits, sheep, livestock equipment, swine, donkeys, dogs and mules. We are currently receiving 100 new ads a day, and over 20,000 unique hits a day.
- Next message: [DB-SIG] Mirroring DBs with Python
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]