Oct 11, 2006 #1 rkasnick Programmer Apr 28, 2003 66 US Does anyone know how long it would take, ballpark, to migrate a 22gb SQL 7 db to a new server with SQL2005 running in SQL 2000 mode? Are there any special considerations to be planned for? Thanks
Does anyone know how long it would take, ballpark, to migrate a 22gb SQL 7 db to a new server with SQL2005 running in SQL 2000 mode? Are there any special considerations to be planned for? Thanks
Oct 11, 2006 1 #2 mrdenny Programmer May 27, 2002 11,595 There are syntax differences between SQL 7 and SQL 2005. The upgrade will take probably 1-2 minutes. The data is stored in the same manor between SQL 7 / SQL 2000 / SQL 2005. Only the meta data is different. Denny MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com Upvote 0 Downvote
There are syntax differences between SQL 7 and SQL 2005. The upgrade will take probably 1-2 minutes. The data is stored in the same manor between SQL 7 / SQL 2000 / SQL 2005. Only the meta data is different. Denny MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com