A couple of questions that will determine the complexity of the process: Do you have any localized data currently in the database? Particularly CJK data or any other type of multi-byte or localized data? Have clients connected to your remedy server using a localized version of windows and entered/pasted or otherwise inserted localized data into your db?
Have you used any non 7-bit ASCII characters in any of your form or workflow definitions (copied any data from word into the notes or change history of any workflow definitions)? What version of ARServer was initially installed when the system was built? What versions of the Remedy User Tool do/have people used (earliest version)? All of the non-Unicode to Unicode upgrades I've done have been from a 6.x o 7.x Remedy server (6.0.1 to 7.0.1 and 6.3 to 7.5), so I can't speak as to how one should upgrade with the versions you are working with. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Tue, Jun 29, 2010 at 6:35 PM, Antonio Monizza <antomoni...@gmail.com>wrote: > ** Hello listers, > > we have a custom application, with ARS 7.1.0 server on AIX machine, > installed in NON Unicode mode and > pointing to AIX db server with Oracle 9.2, characterset UTF8. So database > is already Unicode enabled, ARS is not. > > We are planning to do a major upgrade: we need to have our ARS server in > Unicode mode, > then we will point app server to a new db machine with Oracle 10, > eventually we want to upgrade to ARS 7.5. > > Currently we are focusing on the non Unicode to Unicode upgrade step, so we > are looking for any valuable advise on the topic. > At BMC support they keep on saying that a brand new ARS installation in > Unicode mode is needed (i.e. no upgrade), > and then def+data must be imported at ARS level > > Has anyone of you ever tried to upgrade ARS 7.1.0 from non Unicode to > Unicode mode ‘simply’ changing parameters > and environment variables (LANG and LC_ALL) and locale settings on the ARS > application server, > acting directly on ar.conf and arsystem files, and then doing a > stop/restart of ars server? > > Should a new installation be inevitable, we really want to avoid using > migrator or arimport for data migration > (too many forms, too many data…), and use oracle export/import instead of > whole arschema: > has anyone of you ever tried this option? > > Any advise and suggestion on this topic is very welcome! > > Thanks in advance > > Best Regards, > Antonio Monizza > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
