Is there a way in which I can mov a databse from one server to another? I've been developing a database on my localhost, and when I come to move it online, I'll want to be able to save myself the ...

I'm trying to copy a database from one server (SQL Server 2000 Enterprise Edition) to another (SQL Server 2005 Standard Edition) to make sure the second is suitable as a backend to some terrifying ...