Sponsored Content
Full Discussion: Database Migration
Top Forums UNIX for Advanced & Expert Users Database Migration Post 90161 by matrixmadhan on Saturday 19th of November 2005 06:10:41 AM
Old 11-19-2005
Database Migration

Hi All,

This question is mainly to get help from u all experts for a database vendor change

we are in the process of migrating our database vendor from INFORMIX to ORACLE to run on SOLARIS 9.4 box.
Hence we need to work out on our applications which all are written in native 4GL (an easy interface to communicate with informix database)

I tried in our forum regarding database vendor change and according effect to the application which uses the database but could not find any such

postings, could be this is the first one of its kind?

As we are going to use ORACLE as our database,
1) Do all the applications written in 4GL have to be necessarily re-written in Pro *C/C++? Is there any other alternatives possible for that?

2) Are there any migration tools avaialable with respect to rewriting applications from 4GL to Pro *C/C++ ?
( I am sure data migration across databases are possible)

3) And above all the risks and feasibility of such kind of a task?

(I am aware that I am piling up questions ...)

Your help would be of great value to me.

I am sure some of you experts would have surely had enough and great real time experience in doing such kind of vendor change and challenges faced during such meticulous migration tasks.

If u experts suggest some good websites, links regarding this it would be even more useful and helpful to me.

Awaiting ur reply.

Thanks.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Migration

Is it possible to migrate a UNIX program and use it in a NetWare or Windows 2000 network? I have a client that must have one of those two operating systems for the new program that they want. However, they've been using an older UNIX program for about 7 years and they want to be able to refer to... (7 Replies)
Discussion started by: refram
7 Replies

2. UNIX for Advanced & Expert Users

migration

hi, is there any tool that i can use to update my scripts (SH scripts) form Unix to linux. please mention any useful websites. thanx in advance (2 Replies)
Discussion started by: omran
2 Replies

3. HP-UX

AS/U -> samba migration

Hi, I'm having some trouble finding a suitable howto for a migration process from asu to samba (both running on hpux). Does any kind of automated migration scripts exist? And if not: how to do that from hand? I did several researches at the company's knowledge base and on the internet but... (0 Replies)
Discussion started by: Frank_S
0 Replies

4. UNIX for Advanced & Expert Users

Migration

Hi all, Would appreciate advise on my situation. Currently server A is in production. Server A takes in data from Server X, does some processing and send to server Y. We are going to develop a different system in server B, something like an enhanced version of A. Server A will be retired once... (2 Replies)
Discussion started by: new2ss
2 Replies

5. Solaris

Solaris system and database migration help

HI, let me explain you the current situation. We have three server with OS Solaris and oracle products. Following is the somewhat detail, 1st Server= oracle DB 2nd Server= Oracle Warehouse builder 3rd Server= Oracle Business Intelligence Enterprise Manager Question: these three... (0 Replies)
Discussion started by: malikshahid85
0 Replies

6. Solaris

redirect solaris database from linux database..

hi.. i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database which is in solaris 10 x86... can u tell me the procedure .. how it can be done through php .. sorry am new to php... is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies

7. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

8. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies

9. AIX

AIX - FC Switch migration, SAN Migration question!

I'm New to AIX / VIOS We're doing a FC switch cutover on an ibm device, connected via SAN. How do I tell if one path to my remote disk is lost? (aix lvm) How do I tell when my link is down on my HBA port? Appreciate your help, very much! (4 Replies)
Discussion started by: BG_JrAdmin
4 Replies
CYR_EXPIRE(8)						      System Manager's Manual						     CYR_EXPIRE(8)

 *

NAME
cyr_expire - expire messages and duplicate delivery database entries SYNOPSIS
cyr_expire [ -C config-file ] [ -D delete-days ] -E expire-duration [ -X expunge-days ] [ -p mailbox-prefix ] [ -v ] DESCRIPTION
Cyr_expire is used to expire messages and duplicate delivery database entries. Cyr_expire also cleanses mailboxes of partially expunged messages (when using the "delayed" expunge mode). The expiration of messages is controlled by the /vendor/cmu/cyrus-imapd/expire mailbox annotation which specifies the age (in days) of messages in the given mailbox that should be deleted. Any duplicate delivery database entries which correspond to the mailbox are also deleted at the same frequency. The value of the /vendor/cmu/cyrus-imapd/expire annotation is inherited by all children of the given mailbox, so an entire mailbox tree can be expired by seting a single annotation on the root of that tree. If a mailbox does not have a /vendor/cmu/cyrus-imapd/expire annotation set on it (or does not inherit one), then no messages are expired from the mailbox. Cyr_expire reads its configuration options out of the imapd.conf(5) file unless specified otherwise by -C. OPTIONS
-C config-file Read configuration options from config-file. -D delete-duration Remove previously deleted mailboxes older than delete-duration (when using the "delayed" delete mode). The value can be a floating point number, and may have a suffix to specify the unit of time. If no suffix, the value is number of days. Valid suffixes are d (days), h (hours), m (minutes) and s (seconds). -E expire-duration Prune the duplicate database of entries older than expire-duration. This value is only used for entries which do not have a corre- sponding /vendor/cmu/cyrus-imapd/expire mailbox annotation. Format is the same as delete-duration. -X expunge-duration Expunge previously deleted messages older than expunge-duration (when using the "delayed" expunge mode). Format is the same as delete-duration. -x Do not expunge messages even if using delayed expunge mode (reduces the IO hit considerably, allowing you to run cyr_expire fre- quently to clean up the duplicate database without overloading your server) -p mailbox-prefix Only find mailboxes starting with this prefix. e.g. "user.justgotspammedlots" -v Enable verbose output. -a Skip the annotation lookup, so all /vendor/cmu/cyrus-imapd/expire annotations are ignored entirely. It behaves as if they were not set, so only expire-days is considered for all mailboxes. FILES
/etc/imapd.conf SEE ALSO
imapd.conf(5), cyrmaster(8) CMU
Project Cyrus CYR_EXPIRE(8)
All times are GMT -4. The time now is 09:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy