Sortid
13 years agoLevel 6
Move DA Database
Using EV8Sp5 and also 9SP2 (two separate installations). I have set up a SQL 2008 server to host the EV and DA databases. They currently sit on SQL 2005 servers. I am trying to find instructions o...
- 13 years ago
You were really close, looks like you just missed step 8, you must have had to do this before! :)
8. Modify the following in the CA or DA Configuration database. Replace the original SQL_NetBios server name with the new SQL_NetBios server name.Table Name Column Value tblCustomer Server New_SQL_NetBiosName Open SQL Query Analyzer and run the following query separately against each Configuration database that has been moved. Replace bold items with the correct server name values:UPDATE tblCustomer SET Server = 'New_SQL_NetBiosName' WHERE Server = 'Old_SQL_NetBiosName'