Migration from 7.0 to 2000

• Matthias Nitz

  Grasshopper

  Points: 13

  More actions

  August 5, 2002 at 5:27 am

  #158760

  Hello,

  i need a short howto for a migration of a productive database from sql server 7.0 to sql server 2000. the database contains numbers of blobs, which could cause problems, as i had heard.

  Thanks in advance

  Matthias

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  August 5, 2002 at 7:15 am

  #433996

  A few resources come to mind:

  Microsoft's White Paper on Upgrading to SQL Server 2000:

  http://www.microsoft.com/sql/howtobuy/Upgrade_to_SQL_Server_2000.doc

  SQL Server 2000 Resource Kit Chapter 11 on BLOBs:

  http://www.microsoft.com/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

  Articles at SQLTeam.com on Upgrading from SQL Server 7.0 to 2000:

  http://www.sqlteam.com/item.asp?ItemID=9066 (Part 1)

  http://www.sqlteam.com/item.asp?ItemID=9465 (Part 2)

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley