Q&A: How do I duplicate the whole database to another machine?
Question by YA!!: How do I duplicate the whole database to another machine?
I am using Sybase now.
There are two servers, one is Solaris 8, another is Solaris10.
I want to duplicate the whole database from the old machine, which is Solaris 8, to the new one, which is Solaris 10.
Is it possible to do it? and how to do it?
Thanks
Best answer:
Answer by OZ
Install the database application on the new machine. Then you move just the data to the folders in the application program files in the new machine. The folders will be exactly the same as on the old one, just drag and drop to the same folder on the new one.
Add your own answer in the comments!
Copying files directly can be risky if the database version you are using differs between the two machines. The safest way to do it is to dump the database to a file on the original machine and then load that dump on the new machine.
It really depends what exact sybase software your using, but for example, see the link below:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.commands/html/commands/commands54.htm
You can probably find exact details for your setup at that same address.
Edit: A further example can be found here http://www.mysysad.com/2008/02/dump-sybase-database-to-file.html