How to create a new database based on existing? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to create a new database based on existing?

Message

De

02/04/2008 15:41:36

Tc Holzer
Isle of Man

À

02/04/2008 15:32:14

Dmitry Litvak
Massachusetts, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Maintenance bases de données

Titre:

Re: How to create a new database based on existing?

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01307724

Message ID:

01307735

Vues:

14

http://support.microsoft.com/defaul...b;en-us;Q304692
http://support.microsoft.com/defaul...b;en-us;Q274463
http://support.microsoft.com/defaul...B;en-us;q224071
http://support.microsoft.com/defaul...b;en-us;Q314546
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

>Hello everybody,
>
>I was wondering if there is a quick way to create an "empty" database (all tables with no data) based on some existing database? I need to test an application for different application configurations and would be nice to have several databases for different tests.
>
>Thank you.

.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"

Click here to load this message in the networking platform