If you are on a Dev system, you could try turning on database logging to find out the exact database error that you are getting. You do this by editing the log4j.xml file:
/rxroot/AppServer/server/rx/conf/log4j.xml
Search for the “Uncomment to log all SQL statements from Rhythmyx” entry and uncomment it.
If there is an SQL2005 error, you could try the support.microsoft.com site for info relating to that error. I am not familiar with the SSMA tool and I dont know how it handles unicode when it does the migration, but there is an entry in support.microsoft.com specific to unicode at: http://support.microsoft.com/kb/239530
and it applies to MS SQL Server 2005 (and earlier) releases.
The message seen on server startup is a warning message which is displayed if the Rhythmyx repository does not support unicode characters. It is recommended that the Rhythmyx repository database uses a character set which supports unicode characters. The following excerpt is from the “Repository Database Requirements” section of the “Installing_Rhythmyx_5_7.pdf:”
[I]Note that Rhythmyx does not perform any escaping or character conversion when inserting characters into the database. Therefore, the character encoding of the underlying database character set should match the encoding of the characters you want to store in the Repository. If the encoding of the database does not match the encoding used in Rhythmyx, some functionality may be lost. For example, if you use Microsoft Word as a Content Editor and Oracle as your database, Word SmartQuotes might not work if your database uses a character set other than UTF-8.
Percussion Software makes the following recommendations:
• Use UTF-8 if the majority of the characters you use match the ASCII
character set. This is the recommended option for Western languages.
• Use UTF-16 if the majority of the characters you use fall outside of the
ASCII character set. This is the recommended option for most Asian
languages.[/I]
In the case of MS SQL SERVER 2005, this refers to the collation of your database.