Moving from CMOD V8.4.0.1 to CMOD V9.0

[Ach]

Hi Guys,

One of our customers needs to upgrade from CMOD V8.4.0.1 to CMOD V9.0. The current configuration is as follow:
- OS: Windows 2003
- Database: SQL server 2003
- Storage: TSM 5.5

I know that V9.0 needs at least Windows 2008 SP and SQL server 2008.  So what is the best strategy I can propose to the customer:
1. Just upgrade the current system inclusive Windows and SQL server
Or
2.set up a new system with Windows 2008, SQL 2008 and CMOD V9.0. Then migrate the data from the current system to the new system.

My second question is there a guide for both scenario's (upgrade, migration)? Or could someone describe the steps needed.

Thanks in advance.

Ab

[zeus1996]

Hello, been there done that.
Our environment was the same except OD version 8.4.0.3.
You did not mention about TSM, is it on the same Server as OD or in separate.
Don't know if you already have done something, but option 1 not reasonable.
New setup with mentioned 2008 win and Sql Server 2008 R2 or 2013.
Actually in Sql 2013 the odbc driver did not work from scratch...had to install odbc driver version 10.
And Tsm in separate server, version 6.4 or higher, must be 64-bit environment.

I have exact steps but not reasonable to paste it here.
If you still need more information let me know.

Done this upgrade to 5 environments, one with Sql 2013, and others Od 9.0.0.2 with 2008 R2 and Tsm 6.4

[Ach]

Hi zeus1996,

Thank you very much for your reply.
The TSM server is in a separate server and has the version 5.5.
You have said that option 1 is not reasonable. Could you please clarify why?

Our goal is to upgrade as described below:
Source Environment                       Target environment
Windows 20003 (5.2.3790 SP 2)      Windows 2008 SP2 or later
SQL server 2005 SP 2                           SQL server 2008 SP2 or later
CM8.4.0.1                                      CM9.0.x
V5.5.5.0 (TSMSERVER1)              V5.5.5.0 (TSMSERVER1)                              Separated server.

Yes I am very interested in any information you have to get this done.

Thanks in advance

Ach

[zeus1996]

Hello again !

Ach, i prefer in your case option 2 better because, first of all, support for TSM 5.5 versions ended in April 2014, and its way more secure to build a new environment while the old environment is running smoothly same time, updating is always more risky bisnes.
Besides newer TSM versions 6.2 -> offer quite much more features than the old ones.

You have not mentioned any volume details, or how business dependent ondemand is to your customer.

T:Zeus

[Ach]

The volume is about 150 Gb.
The business needs the document stored in CMOD. However the number of retrievals is not so high (?10/day).

Just one question: 
I agree to set up a new environment with Win2008 64bit, CMODV9, and SQL 2008 64bit.
The current cmod system uses SQL 2003. All software is 32bit.
After new system is ready I know need to take a backup of the database from the current system which is 32bit and load it into the new SQL 2008 which is 64bit.
My question is how to get from a 32bit database to a 64 database Zeus?
Can i load a backup of a 32bit SQL database to a 62bit SQL database?
Or do I need to convert the sql database first which means I have to upgrade the existing SQL server first to SQL 2008 bit and then take the backup?

Thanks in advance

Ach

[zeus1996]

Hi Ach, you dont have to worry about the bits with database.
Just full backup from old database and then when you have new environment restore to new one.
After restore you have to run some update clauses to database which are in the guide in updating to 9.0 from old environment(in your case 8.4.1)
If you have some kind of test environment, or build test instance in the new environment is an other option too.
I can give you further hint if you need them later.
We have been in new environment(same as yours, much bigger allthough) about a year and everything is ok.

T:Zeus