Data transfer from 6.5 to 2000

• *Prashant Thakwani

  SSCommitted

  Points: 1827

  More actions

  April 15, 2004 at 7:00 am

  #85172

  Hi !

  Can anybody tell, how to transfer the sql server 6.5 Data to SQL server 2000. I use the upgrade utility, but it gives an error.

  Prashant Thakwanithakwani_prashant@yahoo.co.in

• Andrew McKeon

  SSC Veteran

  Points: 281

  More actions

  April 16, 2004 at 2:34 am

  #503081

  Hi,

   

  There are quite a few known problems upgrading directly from 6.5 to 2000.  Without the error message it’s a bit difficult to give any specific advice.

   

  Here is a link to a white paper on upgrading from 6.5 to 2000

   

  http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx

   

  I also did a search on the support.Microsoft.com (link below)  and that had numerous resources.

   

  http://support.microsoft.com/search/default.aspx?InCC_hdn=true&Catalog=LCID%3D2057%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&QuerySource=gASr_Query&Product=sql&Queryc=upgrade+database+from+6.5+to+2000&Query=upgrade+database+from+6.5+to+2000&KeywordType=ALL&maxResults=25&Titles=false&numDays=&InCC=on

   

  Sorry I cannot be more specific,

   

  Andrew McKeon