Hi, WE have to migrate wss 2.0 to MOSS 2007 to a completely new environment. The existing wss 2.0 has 150 sites and sizes to 23 gb.Kindly give the steps involved in this. The MOSS 2007 wil be installed in new box.KIndly help me as i am new into this

Already discussed in this forum. Check the below URLhttp://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/d4ce04f0-992b-45f1-8645-3776a7d40c19--Cheers

Hi Llanezll, Regarding to this issue, you can do it as the following workaround: Backup the databases for the sites you want to upgrade. Restore these backups as new databases on the SQL server in your WSS 3.0 farm. Create web applications in WSS 3.0 for the sites that you are going to upgrade.Remove the databases that are created with these web applications through WSS 3.0 central configuration. Now attach the WSS 2.0 databases you just restored to SQL using stsadm -o addcontentdb to the web applications you created in WSS 3.0 for the migrated sites. This is done through the command prompt.To do this navigatec:\program files\common files\Microsoft shared\web server extensions\12\bin andtype this command. stsadm.exe -o addcontentdb -url http://<server>:<port> -databasename <WSS v2.0 content database> -databaseserver <DB Server name> for example stsadm.exe -o addcontentdb -url http://MyServer:80 -databasename WSS_V2_ContentDB -databaseserver Sample This will do anin place upgrade of the database. Note: If youSQL box has instances on ityou will need to specify the instance the database is in for example <SQL Server Name>\<SQLInstanceName> in the <DBServer name> spaceabove. Reference: http://eddyblanco.com/blog/?p=10 Hope this helpful and let me know whether you still need further assistance, glad to help you~!

THanks Lie,It was a very useful tip.PLease give me some clarification on the following issues.1. Should i take the backup of the WSS 2.0 Database in sql server or using the central administrator.THanksAnis

Hello, For your question about backup manner, I suggest you to take the backup of the database in SQL Server by backingup individual content databases one by one. As an alternative option, you can use sp_detach_db and sp_attach_db stored procedure to detach the database file, transfer it to new environment and then attach it. Regards, JerryXing-Bing Yu

All of the above is fine, but you MUST run prescan on the version 2 applicaitons first. WIthout that, NONE of the above will work.