Migrate AdTempus Database from MSSqlServer2005 to MSSqlServer2008

kbirchmore (4 posts)
February 7, 2010 06:42 AM
Accepted Answer

We are currently running our Adtempus database on MS Sql Server 2005.  We have created a box with MS Sql Server 2008 and are looking to phase out the 2005 box.  Does AdTempus support Sql Server 2008? If so, What is involved in moving the Adtempus Database from Sql Server 2005 and Sql Server 2008? 

Kris

J.D. Staff (46 posts)
February 7, 2010 07:19 PM
Accepted Answer

SQL Server 2008 is supported.

To move the database you need to :

  1. Stop the adTempus service.
  2. Detach the adTempus database from the old server (through Management Studio).
  3. Move the database files (mdf and ldf) to the new server.
  4. Attach the database to the new server (through Management Studio).
  5. Edit the adTempus database configuration to point to the new server. See here for information. You need to update the "server=" section.
  6. Start the adTempus service.
Note: if you were using SQL Server security, there will be a userID and password value under the Database key in the Registry. In this case you need to:
  1. Make sure the new SQL Server instance is configured to support SQL Server security.
  2. Create a new login (user ID and password in SQL Server) for adTempus to use. Make sure it has the dbo role for the adTempus database.
  3. Update the userID and password values in the Registry with the new credentials. To set the password, you have to delete the existing value and create it again as a string value.

 If you were using integrated security, you need to make sure that the account the adTempus service is running under has the necessary permissions for the adTempus database on the new server.

See the SQL Server setup topic in the online help for more information on database security configuration.

Replies are disabled for this topic.