2,187
edits
(Added "Migrate SQL2000 to SQL2005") |
m (→Migrate SQL2000 to SQL2005: Minor edit to procedure) |
||
Line 70: | Line 70: | ||
# Restore the database (and log files) to your new SQL 2005 server | # Restore the database (and log files) to your new SQL 2005 server | ||
# Ensure that your Virtual Centre's database account is the db_owner of the Virtual Centre database on SQL 2005 (as it was on the SQL2000 database) | # Ensure that your Virtual Centre's database account is the db_owner of the Virtual Centre database on SQL 2005 (as it was on the SQL2000 database) | ||
# Change the ODBC DSN settings on the VC server so it points to the SQL 2005 server (just change the server name) | # Change the ODBC DSN settings on the VC server so it points to the SQL 2005 server (just change the server name, if you need to specify a non-standard TCP port use <code><SERVER>, <PORT></code> rather than <code><SERVER>:<PORT></code>) | ||
# Restart the Virtual Centre Server service | # Restart the Virtual Centre Server service | ||
# Login using the VI Client and ensure everything looks good (clusters, ESX's, VM's, Alarms, Guest Customisations etc) | # Login using the VI Client and ensure everything looks good (clusters, ESX's, VM's, Alarms, Guest Customisations etc) |