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 ...

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.

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

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.