Home » RDBMS Server » Server Administration » Update entire database
Update entire database [message #357846] Thu, 06 November 2008 22:39 Go to next message
h_jitendras
Messages: 36
Registered: October 2006
Member
I am not sure if this is the right place to post the query here...

We have a 10g d/b on UNIX box at client-site and a local d/b server(OS - Windows 2003 server) at offshore.Now I have to have identical versions of the data on the UNIX box d/b and the one on windows 2003 server.

Can just exporting the data from the UNIX box d/b and copying that dump into the d/b on Windows 2003 server help me achieve this?

Also do we need to handle this differently since we are copying d/b data across diff OS?
Re: Update entire database [message #357855 is a reply to message #357846] Thu, 06 November 2008 23:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, export/import is the way to do it.
Just take to transfert the data in binary (and not ascii) mode between the 2.

Regards
Michel
Re: Update entire database [message #358004 is a reply to message #357846] Fri, 07 November 2008 12:58 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Does the destination database have data in it? If so, then you have to drop all the tables. I am hoping that you are not asking how to synch the destination databases to the source database. Talk about a headache.
Previous Topic: Recover table with deleted records
Next Topic: query about system global area
Goto Forum:
  


Current Time: Fri Nov 29 18:40:56 CST 2024