November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

SQL 2000 to 2005 conversion - Advice?

Jordan Stradtman
Jordan Stradtman
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 26, 2007 18:09
Øyvind Hognestad
Øyvind Hognestad
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 27, 2007 10:00
* 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.