There is also an option in Enterprise Manager to copy a full database to another server. This is really they way to go, not some half assed executing scripts solution.

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site.

The Copy Database Wizard helps you move or copy a database to another server. To access this wizard, I choose Tools | Wizards | Management | Copy Database Wizard.

Catalogic Software, a provider of software-defined copy data management (CDM), has released ECX 2.4, the newest version of its software platform that adds Oracle and Microsoft SQL Server ...