Re: Multiple Databases

Hi .
If you want to pull data from one area to another , you need to consider whether there is referential integrity active on the target database. If there is, simply pulling data from a series of tables may well leave you with RI holes in that data.

To make life even more complex, you also need to consider any logical RI imposed on your data by the application programs you run against that data.

At Tarragon, we deal with a number of Realtional database tools that can help you solve these data movement and manipulation problems.

If you would like some more info, or just to talk thru your problem, please contact me on the below numbers.

Thanks. Alan Johns

        (Technical consultant)
In article <37C82865.8E84D645_at_doitnow.com>, Steven R Fuller <srfuller_at_doitnow.com> writes
>Please Help!!!, What is the best way to pull data from one dataabse to
>another.
>
>I want to extract data from database 1, called prod1
>manipulate the data
>and load it onto database 2, called prod2
>
>Is this depenendent upon the tnsnames.ora file? At this point I have to
>disconnect
>from prod1 and reconnect to prod2
>
>
>
>[ A MIME text / x-vcard part was included here. ]
>

Best regards
--
  Alan Johns
  Tarragon Software Ltd - UK & Ireland Distributor for

        Princeton Softech's - 
                Upgrade 2000
                Ager 2000
                Relational Tools for DB2
                Move for Servers - Oracle, DB2, Sybase, SQL Server
                SyncPoint
                Version Merger

        DBE Software - DB Examiner for Oracle, DB2, Sybase, SQL Server

Phone: 44(0)1480 414141
  Fax: 44(0)1480 436869 Received on Tue Aug 31 1999 - 03:27:04 CDT