<div>
1. Do a Full backup, restore on the target folder.<br />
2. When you are ready do a Differential backup and restore.<br />
<br />
This last step should only take you a few minutes, depending on the changes since the Full backup.
</div>


1. Do a Full backup, restore on the target folder.
2. When you are ready do a Differential backup and restore.

This last step should only take you a few minutes, depending on the changes since the Full backup.

<div>
and that 100% works between these 2 different versions of SQL Server?<br />
<br />
What establishes the &quot;snap&quot; point on the backup (and does the application need to be down to do that full backup)?
</div>


and that 100% works between these 2 different versions of SQL Server?

What establishes the "snap" point on the backup (and does the application need to be down to do that full backup)?

<div>
<div class="content wysiwyg-content">
We have a fairly large production SQL Server 2000 DB that is used 24x7.<br />
<br />
We want to upgrade to SQL Server 2005 to deal with some deficits of SQL Server 2000.<br />
<br />
I'd like to have a small a window on this as possible and would like to be able to take an export and migrate that and then only apply deltas between the two. &nbsp;We do this with Oracle (but I think only with the same version).<br />
<br />
Is there some way to do this with SQL Server 2000 and SQL Server 2005 (going from one version to the other)?
</div>
</div>


We have a fairly large production SQL Server 2000 DB that is used 24x7.

We want to upgrade to SQL Server 2005 to deal with some deficits of SQL Server 2000.

I'd like to have a small a window on this as possible and would like to be able to take an export and migrate that and then only apply deltas between the two.  We do this with Oracle (but I think only with the same version).

Is there some way to do this with SQL Server 2000 and SQL Server 2005 (going from one version to the other)?

Replicating SQL Server data cross version?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.