Link to home
Start Free TrialLog in
Avatar of whistlerblackcomb
whistlerblackcombFlag for Canada

asked on

new bes 4.1 server and new remote sql server - migration

we currently have bes 4.1 for exchange running on a 2003 server using a remote sql 2000 db. We have 28 users.
 
we want to move bes to a new server and move the db to a new remote sql 2005 server.                                                                                                                                                                                                                                                                                                    I've read about the "knife edge cutover", RIM bes migration and db migration docs but am still a little confused.

I've set admin permissions and db permissions on new servers. will be using same credentials for services.

I've tried this:
1.backup the current db
2.update the schema on the new db server
3.restore the db to the new db server
4. stop services on current bes server
5. install bes on new server with cals and srp key and point to use db on new remtoe sql server
6. start services on new bes server

BB dispatcher would start then stop.

do I need to do these steps:

1. update the db schema on the new sql server or can I just backup the current db and restore to new server?

2. Make change to db tables as below:

Now that the database has been restored within SQL Manager you need to expand the BESMgmt database and select Tables. In the centre window right mouse click ServerConfig and select Open Table. Now edit the columns below and update them to display the new server name.

-ServiceName
-MachineName
-RPCEndPoint (only edit the name after \pipe\BESMonitor )

Now select the Tables folder in the left column again. In the centre window right mouse click MDSConfig and select Open Table. Now edit the columns below and update them to display the new server name.

-MDSHost
-MachineName
-ServerName (only edit the name before _MDS-CS_X)

I understand I need to keep the same bes server name, but can change the machine name. the current machine name is twbes i've named the new machine is srv-bes.

any help is appreciated
ASKER CERTIFIED SOLUTION
Avatar of SysExpert
SysExpert
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial