We have two SQL server installations on different machines. In ole' Enterprise Manager, it was easy to use their Data Transformation tools (Import/Export) to move data and schema back and forth.
What is available for SQL Server 2005? Anything in Visual Studio 2005? Or SQL Server Studio Management Express?