<div>
The easiest would be to use SSMS to generate the necessary scripts, copy them to the other computer, and then run them. <br />
<br />
Select the database, right-click, Tasks &gt;&nbsp;Generate scripts. Then walk through the wizard to make your choices.<br />
<br />
You could write all of the scripts by hand, but it would take a while. 
</div>


The easiest would be to use SSMS to generate the necessary scripts, copy them to the other computer, and then run them.

Select the database, right-click, Tasks > Generate scripts. Then walk through the wizard to make your choices.

You could write all of the scripts by hand, but it would take a while.

<div>
Of course, another way to do it would be to create a backup and then restore it as a new database. 
</div>


Of course, another way to do it would be to create a backup and then restore it as a new database.

<div>
I want to do this from a .NET application which is why I need to figure out how to do it using SQL commands. 
</div>


I want to do this from a .NET application which is why I need to figure out how to do it using SQL commands.

<div>
Do you mean to copy the data also ? In such case use BACKUP /RESTORE 
</div>


Do you mean to copy the data also ? In such case use BACKUP /RESTORE

<div>
Are you trying to clone the entire database, certain tables, tables with data, or just the data?
</div>


Are you trying to clone the entire database, certain tables, tables with data, or just the data?

<div>
The whole thing. I want to take a snapshot of the database at a moment in time. If my database was called DB_LIVE then a snapshot would be a functional database called DB_LIVE_20070822 which is an exact clone of the database as at today. Backup/restore would be fine but I need to send the instruction as a SQL command from the app.<br />
<br />
<br />
<br />
<br />
<br />

</div>


The whole thing. I want to take a snapshot of the database at a moment in time. If my database was called DB_LIVE then a snapshot would be a functional database called DB_LIVE_20070822 which is an exact clone of the database as at today. Backup/restore would be fine but I need to send the instruction as a SQL command from the app.







<div>
<div class="content wysiwyg-content">
How would you copy a database using SQL commands?
</div>
</div>


How would you copy a database using SQL commands?

SQL Command to clone a database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.