Precision, Performance, Confidence. ™

Moving a MET/TEAM database to a different server

Three major operations need to be performed to execute a successful database move:

1) Relocate the database on the new SQL instance.

2) Point the MET/TEAM website to the new database.

3) Re-register the application (because moving the database requires re-licensing to the new DB server).

I Relocate the database 

1) To prevent modification of the data during this process, first stop the MET/TEAM website in IIS.  Please see this article: How to Stop, Start or Restart the MET/TEAM website in IIS

How to Stop, Start or Restart the MET/TEAM website in IIS

2) Back up the database on the old SQL Instance. Please see this article: How to manually back up a MET/TEAM database

How to back up a MET/TEAM database


3) Restore the database on the new SQL Instance. Please see this article: How to manually restore a MET/TEAM database

How to restore a MET/TEAM database


II Point MET/TEAM website to the new database 


1) On the web server, open IIS. 
2) On the left panel, expand the connections until you get to the MET/TEAM site. Select that site. 
3) In the middle panel, there is an icon for Connection Strings. It looks like a yellow cylinder. Double-click it. 
4) In Connection Strings, double-click on the entry titled "MetTrack_Dev" and edit the connection string's server setting to point to the newly installed SQL Instance. 


5) Repeat steps 2-4 for the Customer Portal Site, if necessary. 
6) Open the Registry Editor. 
7) Go to the following key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EmailAlerts 


8) Double click on the ImagePath key value, and edit the string's SQL Instance so that it points to the new instance.


III Re-register the application 


1) Run the following SQL command against the database:


DELETE FROM dbo.Licenses 
UPDATE dbo.Servers SET mNotes = NULL

If instructions are needed, please see this article: 

How to run SQL scripts for MET/TEAM


2) Start the website in IIS. (For instructions, use the same article mentioned above in step I 1: How to Stop, Start or Restart the MET/TEAM website in IIS.

3) Attempt to log into MET/TEAM and register it in the normal manner.

If instructions are needed, please see this article: 

How to request and apply License(s) for MET/TEAM


If you see a database logon failure when you enter the website, it is most likely because the user account that is running the website has insufficient privileges to access the new database. If you go into IIS and enter the Application Pools screen, you can see the user account running the MET/TEAM application pool (under the Identity column). This account needs to, at the very least, be a db_owner of the new server's MET/TEAM database.

Have more questions? Submit a request

Comments

Please sign in to leave a comment.