RE: Need to setup a client database

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 27 Oct 2004 12:50:21 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6501CC8E53@25exch1.vicorpower.vicr.com>

Lizz,

Personal Oracle is licensed by each desktop/laptop it's installed on. It's $400 per user. Oracle Lite may be a better choice as it appears to have the synchronization features you'll need built in. It's $100 per user.
Another potential platform in iAnywhere from Sybase. Have seen a demo of their synchronization process a couple of years ago. It was damned slick back then, should be better now.=20

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----

From: laura pena [mailto:lizzpenaorclgrp_at_yahoo.com]=20 Sent: Wednesday, October 27, 2004 12:29 PM To: oracle-l_at_freelists.org
Subject: Need to setup a client database - advice

We have the need to for small database on our clients systems.=20 Currently we are storing all data for all our customers in an Oracle 9iR2 database.=20
There is a need for clients to have a small mysql, postgress, firebird database for storing a days worth of data. That data is to be downloaded nightly to our "mothership" oracle database. The tables on the client side will be in fact a small subset of the "motherships" database.

Question I have so far:
- has anyone done something like this before? If so, which client
database was chosen and why?=20
- Can I run personal oracle on the client database without a license?

what was used as your migration processes (ie. flat files?) -What are licensing issues we will have to deal with?
any other information I may need to think about and have not asked would be highly appreciated.

Many Thanks,
-Lizz

=09

Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 27 2004 - 12:06:28 CDT

RE: Need to setup a client database - advice