If you're just looking to migrate data one-time, the import/export wizard can help:
http://go.microsoft.com/fwlink/p/?LinkId=167982[
^].
SQL Server Integration services can also help (even if you don't need to migrate and change the schema) but that may have been introduced in SQL Server 2008.
If you need to do this regularly, you may rethink your design. This can be expensive and prone to merge errors. What you could do instead is replicate the database to other servers. See
http://msdn.microsoft.com/en-us/library/ms151198(v=SQL.90).aspx[
^].