Moving from Unix to Windows

10 pts.
Tags:
Itanium Servers
Oracle administration
Unix
unix to Windows Database Migration
Windows Server 2003
We are contemplating moving our databases from the Unix platform to a Windows platform. The Windows servers we are thinking of purchasing are Itanium. We have been told that we can just copy the datafiles from the Unix platform to the Windows platform and everything should work fine. I am not so sure and would appreciate your feedback on this and how to approach this migration with minimal downtime. Is the fact that the Windows servers are Itanium be of any concern or is it a non-issue?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello.

This situation is not that easy, it depends from what Database you are using (what RDBMS). If you are talking about MySql, this can be done that way, but before copying the database, you need to stop de MySql service, so the data is consistent, and then you can do your backup. In the other server, the MySql must be the same version, and the MySql service must be stopped too. After restoring your previous backup, and starting the MySql service, you will see your data in the other server.

If you are using a Oracle backup, you will need to do a Full Backup, using the backup tool provided with de Oracle software (export command).

If you are changing from one RDBMS to another, then you need to do a dump of the data, in SQL Standard format, so you can restore or import to another RDBMS with minimal or nothing troubles.

Talking about the hardware, this is not relevant to the database server, and Itanium is a good processor.

I hope this helps you.

Best regards.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following