SQL 2000 to 2005 conversion - Advice? | Optimizely Developer Comm

SQL 2000 to 2005 conversion - Advice?

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

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