Re: Copying Databases

You could also try a tool called 'Move for Servers' from Princeton Softech. Being a relational data extraction and insertion tool, you could extract the entire database to an extrcat file, both object definitions and data, and then use the tool to create the database on a second DBMS.

If you would like any more info, contact me at the below address, phone or e-mail me.

Thanks.
In article <6ro4om$smn_at_bgtnsc01.worldnet.att.net>, Takafumi Kamiya <takakami_at_worldnet.att.net> writes
>You can do this in two ways.
>
>You can export and import the database
>or
>You can copy the database files and recreate the control files.
>
>
>In article <6r66ol$8s7$1_at_platane.wanadoo.fr>, gary.anderson_at_wanadoo.fr says...
>>
>>How would one copy a database from system to another system or from one file
>>system to another? What precautions are necessary? Control files?
>>
>>Thanks for any info on this subject.
>>
>>
>

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
                                Version Merger
        
        ELISE - the MatchMaker. Software for recruitment, estate agencies,      
                                dating agencies, etc from WCC

Phone: 44(0)1480 414141
  Fax: 44(0)1480 436869