Quest Software has several solutions in this area. Our middleware solutions
will provide a full extraction and conversion to SQL, Oracle, DB2 or flat
files. We have various methods that range from real-time to bulk load copies
and transportation. Please visit www.quest/com/mpe or call us at
1-800-306-9329. We have helped many HP3000 cusotmers in this area where
others have failed.
-----Original Message-----
From: Birket
To: [log in to unmask]
Sent: 11/8/2002 1:47 PM
Subject: Re: Suprtool Extraction
In article <[log in to unmask]>, "Gopalakrishnan,
Thiyagarajan
(Cognizant)" <[log in to unmask]> writes:
>,
> I had been facing one problem regarding Suprtool Extraction.Whether
it is
>possible to extract the entire data base and put it into the flat
>file(instead of doing it for each and every dataset in the
database)..If
>possible..how we can do it???..where i can get information regarding
this...
>
I don't think you want to put it in one file ... you may however wish to
run a
batch job which extracts all of the files into separate flatfiles each
named
differently ... or you could be looking at UDACentral from MBFoster to
build
the same structure in Oracle or Sql Server and then move the data
between
platforms ....
It is useful to consider why you are moving the data and what needs to
be moved
... you may not want to convert some of the older history at the detail
level
.... rather convert it to a summarized by LOB or date range, sales
territory
eetc.
You will also probably have to think about dates 99999999 is not a valid
date
if you are importing to Eloquence, and spaces in numeric fields won't
move over
either ... you really need to think about how you Extract, Transform,
Clean,
and Load.
Birket
PS there are lots of ways to do this see our website at MBFoster.com or
the
spreadshet of products a www.hp.com/go/e3000partners
Birket Foster
M. B. Foster Associates .. the 1-800-ANSWERS people!
Supplying UDALink w/cross-platform ODBCLink Option (3000,9000&NT)
See how DataExpress has evolved www.MBFoster.com
EC/EDI(3000,9000,NT) Phone (613) 448-2333 or (613) 448-2588(FAX)
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
