Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL++ - Programming with the C++ API to MySQL
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
Migrating SAP DB 7.4 ASCII to 7.6 Unicode

Migrating SAP DB 7.4 ASCII to 7.6 Unicode

2006-11-22       - By JUNG, Christian

 Back
Reply:     1     2  

Hi,

as mentioned in my last mail, we want to upgrade our old SAP DB 7.4 database
systems to MaxDB 7.6.

Our source system is a SAP DB 7.4.3.27, 32 Bit, ASCII. The destination
system is a MaxDB 7.6.0.33, 64 Bit and we'd like to run it in Unicode mode.

We tried to recover a full backup into the new system. But this wasn't
possible because the backup was made with an ASCII instance and we tried to
recover it in an Unicode instance.

Then we recovered it in an instance, where we defined _UNICODE NO. This
worked very well but it was ASCII. And this parameter isn't changeable
anymore :-(

But I remembered that our SAP systems made this step (convert the catalog
from ASCII to Unicode). And then I found the (rather undocumented) function
db_migratecatalog, which has to be executed in OFFLINE state. It finished
its work and voila: _UNICODE YES.

Is this the (secure) way to convert a database or should we use a different
strategy?


bye
Chris

phone: +49 6898/10-4987
fax: +49 6898/10-54987
http://www.saarstahl.de

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=mysql@(protected)