Upgrading to Serena Business Mashups. Presented by: Ethan Goldberg. Before you Begin. Review the moving to SBMS guide. Know your ODBC connection Username and Password and the port number for your database (Default is 1521 for Oracle and 1433 for SQL Server)
Upgrading to Serena Business Mashups
Presented by: Ethan Goldberg
Always run the utility if your Database is SQL
If using an Oracle database running the utility depends on a combination of factors.
During the Unicode Upgrade Utility, in a nutshell, all text fields are translated to Unicode text fields. For example all varchar fields are converted to nvarchar. But, how is that accomplished?The utility steps through each table in the database and does this:- Creates a Temp table with columns matching the target table's text fields, but in Unicode.- Copy the data from the target table into the temp table- Drop the columns in target tables and recreate them as Unicode compliant columns- Copy the data back from the temp table to the target table- Drop the temp table and start over again with the next target table
Because Unicode uses 2 bytes to describe each character, there can be significant increases in the size of each ROW in a table. This is especially important in MS SQL Server because of the row size limitation of 8060 bytes. This is a hard limit and will cause the Unicode Upgrade Utility to halt. You will need to clean out some columns and restart the upgrade from the beginning.
Two important points to remember:1. The resulting database may be twice as large as the old TT 6.6.1 database, so make sure that they have plenty space for the database to grow.2. Always, always backup the database before doing the utility, so that you have a clean copy to revert to in case of a failure.
Answers For Your Questions