How to copy a Sql Server Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angella Andrea - 31 Mar 2008 15:50 GMT

Hi, how can I copy the schema and the content of tables from one database to
another ?

Thank you

Andrea

Reply to this Message

Tom Moreau - 31 Mar 2008 16:22 GMT

Just do a backup and restore.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

Hi, how can I copy the schema and the content of tables from one database to
another ?

Thank you

Andrea

Reply to this Message

Rubén Garrigós - 31 Mar 2008 17:00 GMT

You can also use the "Copy Database" task wizard in SQL Server Management
Studio (if you are using SQL Server 2005).

Signature

Rubén Garrigós
Solid Quality Mentors

> Hi, how can I copy the schema and the content of tables from one database
> to another ?
>
> Thank you
>
> Andrea

Reply to this Message