<div>
options<br />
1. backup at A and restore at B<br />
2. generate the scipt of the database using (database publishing wizard) and execute the same at destination<br />
3. replication 
</div>


options
1. backup at A and restore at B
2. generate the scipt of the database using (database publishing wizard) and execute the same at destination
3. replication

<div>
What does that mean to 'backup'? I don't need the whole server only 1 database in the server. The data wold be groing from sql2k to sql express. I think it just might be easist to write a .NET app to do it. I can manage 2 connections and do what I need. I was just wondering if there was some standard protacol I was missing.
</div>


What does that mean to 'backup'? I don't need the whole server only 1 database in the server. The data wold be groing from sql2k to sql express. I think it just might be easist to write a .NET app to do it. I can manage 2 connections and do what I need. I was just wondering if there was some standard protacol I was missing.

<div>
<div class="content wysiwyg-content">
What would be the easiest way to copy a database from a SQL database to a SQL express databse on my local machine?
</div>
</div>


What would be the easiest way to copy a database from a SQL database to a SQL express databse on my local machine?

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