Re: Migration from Informix to Oracle 7.3.3

This is a multi-part message in MIME format. --------------82FDAA06D2CD09475F8B7122 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit <<YA-ALI>> QueriX compiles 4GL code to create executables with out the need to use ODBC to connect to Informix or Oracle. The 4GL code remains the same. And there is NO RUNTIME FEE to pay. Odessit wrote: > > On 7 Jan 1998, Nigel Gall wrote: > Here is my experience with Oracle/Informix: > we are running 4gl parsed to odbc/C to access Oracle, > "straight" 4gl to go after Informix. > > Time to setup database (after you have configuration defined): > Informix -- 10 minutes > Oracle -- 2 hours > > Triple (at least!) hard disk space and memory on Oracle. > > > > }From the looks of things after installing 7.3.3, (well, starting to > > }install it anyway.) It seems that oracle can only serve a single database > > }per instance. This means we would have to run 60+ instances of oracle on > > }the DB server, does it not? Many of the databases have identical tables > > }and are archive versions of the main database. I.e. the Fall Semester > > }1996 student database. > single database per instance is correct... Your solution will work, but > amount of CPU/disk/memory required needs to be estimated quite > carefully! I would try structure like: using database name (in Informix) > as user name (in Oracle), but I am not sure if it will work with > identical table names. > > > } > > }Oracle does not seem to support .rhosts/hosts.equiv authentication, so it > > }looks like we'll have to move to embedding the passwords in the perl > > }scripts that connect to the database server (or in a local file or similar). > > } > will OS level authorization work for you? > > > }Does anyone have any pointers or tips for going about this migration > > }process. At the moment, I am still struggling with just getting Oracle up > > }and running to where I can connect to it remotely. > Good Luck, I spent few days getting my Oracle database setup first > time, > > Alex --------------82FDAA06D2CD09475F8B7122 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Mehdi Afshar Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Mehdi Afshar n: Afshar;Mehdi org: QueriX (UK) Ltd. email;internet: mehdi@querix.co.uk title: MD note: URL: http://www.querix.co.uk/ x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------82FDAA06D2CD09475F8B7122--