Need urgent help on Imports and Exports of Data

• Joe William

  SSC Enthusiast

  Points: 133

  More actions

  March 21, 2007 at 4:36 pm

  #176882

  I would be most grateful if anyone could help me on how to import and export data from one database to the other in sql server 2005. I am fining it difficult because I am new to sql server 2005. Unlike sq server 2000 when you right click a table it will give you the option of imports and exports but sql server 2005 is not like that. I am using sql server 2005 express with service pack 2. Moreover I would like to know if you attach a db to sql 2005 is possible to copy the same db to different machine which is running sql 2000 and attach the db. I am asking because I could not attach my old sql 2000 db which I attached to sql 2005 and because of difficulties with sql 2005 I wanted to attached it to sql 2000 which I am familiar with but getting this error message (Error 602: Could not find roll in sysindexes for database ID8, object ID1, index1, Run DBCC CheckTable on sysindexes).  Thanks for your help

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 21, 2007 at 11:10 pm

  #696300

  If you want to copy the data from one database to another database on the same server you don't need to use dts package...

  It can be done using TSQL...

  Insert into db1.dbo.table1

  select * from db2.dbo.table2

  OR

  If you have sql 2000 client tools installed on your laptop... you can use dts package from your laptop to copy the data....

  Note: You can restore sql 2000 backup to sql 2005 but not other way around... it is one way

  MohammedU
  Microsoft SQL Server MVP