Monday, March 26, 2012

moving a db

How can I move data in a SQL Server 2000 DB to an SQL Server 7.0 DB?Dave,
You can copy the data over to SQL Server 7 using DTS or BCP.
You can't move the entire database with backup/restore or
sp_detach_db/sp_attach_db due to the version
incompatibilities.
-Sue
On Wed, 28 Jul 2004 09:21:15 +1200, "Dave Bartlett"
<davebartlett429@.yahoo.com> wrote:

>How can I move data in a SQL Server 2000 DB to an SQL Server 7.0 DB?
>

No comments:

Post a Comment