|
Home > Archive > MS SQL Server New Users > April 2005 > A database clone
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| juValdiv 2005-04-22, 11:23 am |
| Is there a simple way to copy an entire database to another new one?
I need to copy my production database to another for training purposes.
Thanks for your help,
Juan.
| |
| Francesco Anti 2005-04-22, 11:23 am |
| If you need data, you can use a DTS or Backup/Restore. Elsewhere you can use
the SQL script that creates the database (that you can obtain from
Enterprise Manager..database\all task\ Generate SQL script)
Francesco Anti
"juValdiv" <juan@abacor.net> wrote in message
news:e3S44S1RFHA.3716@TK2MSFTNGP14.phx.gbl...
> Is there a simple way to copy an entire database to another new one?
>
> I need to copy my production database to another for training purposes.
>
> Thanks for your help,
>
> Juan.
>
>
>
| |
| juValdiv 2005-04-23, 3:23 am |
| Thanks, I did it exporting the database...
"Francesco Anti" <fanti_@_sicosbt.it> escribió en el mensaje
news:#PcSzX1RFHA.3144@tk2msftngp13.phx.gbl...
> If you need data, you can use a DTS or Backup/Restore. Elsewhere you can
use
> the SQL script that creates the database (that you can obtain from
> Enterprise Manager..database\all task\ Generate SQL script)
>
> Francesco Anti
>
> "juValdiv" <juan@abacor.net> wrote in message
> news:e3S44S1RFHA.3716@TK2MSFTNGP14.phx.gbl...
>
>
|
|
|
|
|