The migration utility migrates all resellers, organizations, users and databases from one MS SQL 2000 resource (called the source server) to another MS SQL 2005 resource (called the destination server).
This article explains the tasks that you must perform after you migrate to the Ensim Unify MS SQL 2005 server. After the migration is complete, perform the following changes in the connection strings before using the migrated Ensim Unify MS SQL 2005 server.
The connection string is a string passed in the code that specifies the connection information your Web application requires to connect to the database.
This is required because after the migration the connection string continues to use the IP address of the Ensim Unify MS SQL 2000 server, instead of the IP address of the Ensim Unify MS SQL 2005 server.
After migration the migration utility changes the password of the MS SQL 2005 database user to the password of the Ensim Unify user, whereas the connection string continues to use the password of the MS SQL 2000 database user. You must change the password in the connection string, so that the Web sites/application can access the Ensim Unify MS SQL 2005 Hosting Server.
For Example:
Editing the connection string of the Web sites/applications (constring):
constring="driver=<driver of database server>;server=<ip>;database=<databasename>;uid=<user credentials>;pwd=<password>;"
Where:
<driver of database server> is the driver of the Microsoft SQL 2005 database server.
<ip> is the IP address of the Ensim Unify MS SQL 2005 database server.
<database name> is the name of Ensim Unify MS SQL 2005 database.
<user credentials> is the log in ID of the Ensim Unify MS SQL 2005 database user.
<password> is the password of the Ensim Unify MS SQL 2005 database user.