Princeton have definitions for ClarifyCRM, Oracle Apps and PeopleSoft
indicated on their website. I'd strongly suggest talking to their rep's if
you are interested though...
They have excellent support staff and have always been helpful. Plus I
have been told, but don't specifically have figures, that their pricing is
very good.
In terms of configuration I defined all relationships for about 150 tables
and then defined an access path - Which explains where to start doing the
extract and then how to traverse up and down relationships to get all
required data. I spent a week or two setting this up but at the time I was
new to the system and didn't understand the relationships. Ongoing
maintenance as the application evolves is always quick and easy.
Other bonuses include the ability to move data between different DBMS
technologies (DB2, Oracle, SQL Server, Informix, Sybase, etc), and is aware
of native tools such as SQL Loader to speed things up.
Can you tell I was impressed when I was introduced to this product? It was
one tool I didn't mind being forced to implement.
Jared Still
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
om> cc:
Sent by: Subject: RE: Export / Import Question
[EMAIL PROTECTED]
.com
12/01/2004 13:04
Please respond to
ORACLE-L
A tool such as this would be much more useful if it were
to come preconfigured for use with well known apps, such
as SAP for instance.
It doesn't per chance have such an option does it?
Most ERP systems have far too many tables to try and
do this on your own, unless you are working for a rather
large company that can spare the expense.
Jared
On Sun, 2004-01-11 at 13:44, Mark Richard wrote:
>
>
>
>
> Hi Ron,
>
> If it's going to be an ongoing occurance you might want to consider
> Princeton Softech's "Relational Tools for Servers" suite. In particular,
> the Move for Servers product.
>
> I use it to populate up to 20 different development / testing
environments
> with a relationally intact subset of data from production. If your
> database has RI it's a breeze, but even if you don't have RI defined in
the
> database (like we don't) then you just have to teach it the relationships
> once. Since our production environment is around 1.5TB, Move for Servers
> makes it a breeze to just extract a sample of 500 customers - enough to
> test almost all functionality but still nice and small.
>
> I highly recommend this product - and they aren't even paying me to say
> that!
>
> Regards,
> Mark.
>
>
>
>
>
> "Smith, Ron L."
> <[EMAIL PROTECTED]> To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
> [EMAIL PROTECTED] Subject: RE: Export /
Import Question
> .com
>
>
> 10/01/2004 04:29
> Please respond to
> ORACLE-L
>
>
>
>
>
>
> That would require effort and planning on their part.
>
> Ron
>
> -----Original Message-----
> Sent: Friday, January 09, 2004 11:05 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Ron - You may want to ask yourself what you're getting into. My
> preference is that the developers be creating scripts to make their
> procedure, function, trigger changes, along with detailed instructions
> for installing them. I make my counteroffer that I will recover a copy
> of the production database from backup from them. Then they can run
> their scripts just like they or I am going to in production. On the
> other hand, if you have a lot of time on your hands, the challenge of
> just refreshing the data, disabling/reenabling constraints may amuse you
> for an afternoon. Just kidding, sort of.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -----Original Message-----
> Sent: Friday, January 09, 2004 8:09 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I have a user who want to refresh only the DATA in a test database with
> DATA from the production database. He does not want to replace any
> procedures, functions, triggers, etc...
>
> My question is, if I do a full or user level export, then turn around
> and do a full or user level import with IGNORE=Y (after truncating the
> tables) will the procedures, functions, triggers be replaced anyway? I
> have a feeling they will.
>
> If so, is there any way to prevent this?
>
> Thanks!
> R Smith
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Privileged/Confidential information may be contained in this message.
> If you are not the addressee indicated in this message (or responsible
for delivery of the message to such person), you may not copy or deliver
this message to anyone.
> In such a case, you should destroy this message and kindly notify the
sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3
9612-6999.
> Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
> Opinions, conclusions and other information in this message that do not
relate to the official business of Transurban Infrastructure Developments
Limited and CityLink Melbourne Limited shall be understood as neither given
nor endorsed by them.
>
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mark Richard
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply
e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail
for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the
official business of Transurban Infrastructure Developments Limited and CityLink
Melbourne Limited shall be understood as neither given nor endorsed by them.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Richard
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).