SQL 2000 to 2005 conversion - Advice?

Vote:
 
G'day. A client, whos site we just finished, has thrown a slight wrench into the works. Originally, they were going to use SQL 2000, but since have upgraded their servers to SQL 2005. Has anyone gone through a conversion of EPiServer from one database to another and if so, can you give me any suggestions to make this as seamless as possible. Any advice would be greatly appreciated. Jordan Stradtman
#12982
Mar 25, 2008 18:35
Vote:
 
Take a backup of the database and restore it in MS SQL 2005. Change the EPsConnection to the new databaseserver and add the user you use in the connection string in the database. You could also take a look at this FAQ : http://www.episerver.com/en/EPiServer_Knowledge_Center/FAQ_EPiServer_4/1010/Problems_with_remote_connections_in_SQL_2005_Express/
#15203
Mar 25, 2008 18:46
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.