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)?