Moving data from sql 2005 tables to sql 2000 tables

• rguess

  Newbie

  Points: 1

  More actions

  February 4, 2009 at 9:48 am

  #218234

  What I need to do is move the data from one table in 2005 to 2000. The tables are set up the same in both places. I know I could export from 2005 and than import, but we need to do this alot so all I want to is run the statement.

  Please help.

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9149

  More actions

  February 4, 2009 at 10:07 am

  #938157

  Hi

  Check out the below link

  http://www.codeproject.com/KB/database/MovingSQLServer2005to2000.aspx

  http://scottelkin.com/uncategorized/how-to-downgrade-a-database-from-sql-server-2005-to-sql-server-2000/

  Thanks -- Vj

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers