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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
cyr_expire
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)