I am building my website on the testing machine base on the Windows XP + IIS5.1 + SQLExpress 2005.

I can clone the website by copy all the data folder from the source to the target machine and setup database related if both platforms are the same.

I found the DotNetNuke database in the SQL Express 2005 looks like empty. (no table find in the DotNetNuke database.)

So I think this is why migration can work by just copying the data.

But I want to migrate the website form Windows XP to Windows Server 2003 later.

I think there may be two cases possible :

1. Windows Server 2003 + SQL 2000 (SMS pro platform)

2. Windows Server 2003 + SQL 2005 Express (SMS standard platform)

Why should I be careful and do for both cases? Still just copy data folder? Or something else?

What's the database role in the DotNetNuke setup. (Because I got confuse why my SQL Express database is empty?)

Thanks for helping me to solve this issue.

What about the Server 2003 + SQL 2000.

I will buy the Small business server 2003 this month.

Currently SBS has two version.

Pro verion is standard version + ISA Server 2000 +  SQL Server 2000 + Microsoft Office FrontPage® 2003

It's look like I can save a lot of money if I by pro version and want to have all feature. (The price buying only SQL Server 2000 is more than the SBS server standard. )

That mean if I want to use SQL 2005 + SBS standard solution, it may be double price than the SBS pro version.

So current solution I may have is

SBS standard + SQL Express 2005

or

SBS Pro (But with SQL 2000)

Could you give me some opinion of these two cases?  Thank you for your help.