Hello Kevin, You are right, if the machines have the same kind of byte swap and if you can restore a backup of an instance of type OLTP successfully the migration to the new machine can be considered successful. So the rules for migrating from one machine to another using backups are:
1. Byte swap must be identical on both machines. Note that byte swap depends from used processor type and sometimes from the used operating system. 2. If you change the operating system during the migration, the used MaxDB version must be new enough to allow the migration. If the backup can be restored on the new machine the used MaxDB versions were new enough. Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Kevin Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 7:03 PM To: Maxdb (E-mail) Cc: Heinrich, Tilo Subject: RE: copy a complete database to a different server Actually I have imported a Dual AMD Opteron DB instance onto a single proc AMD Athlon machine without a problem, just have to do a restore with initialization so you can adjust the db parms. -----Original Message----- From: Heinrich, Tilo [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 8:06 AM To: maxdb@lists.mysql.com Subject: RE: copy a complete database to a different server Hello Heidi, If you do not change the processor architecture during the move you can use a backups. Otherwise you have to use the loader for the migration. Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 2:05 PM To: maxdb@lists.mysql.com Subject: copy a complete database to a different server hello, I'm facing the following task: we are running sapdb 7.4.3.025 with only one database which has to be moved to a different server (on a different computer). How could I manage this? Is there a possibility to use a (complete) backup or do I have to write out files with the repmcli or something like that? Is there any supporting functionality that comes within the dbm which I hadn't seen yet? Did anyone do the same before? Any advice welcome! regards Heidi Rufer -Entwicklung- Kern AG Hildastr. 66 D-79102 Freiburg Fon: +49-761-791 878-150 Fax: +49-761-791 878-9 mailto: [EMAIL PROTECTED] http://www.kern.ag -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
