Post reply

Transfering Tables and indexes from SQL 2000 to SQL 2005

  • December 12, 2008 at 10:44 am

    #129223

    On a nightly basis, I have transferring data from a production SQL 2000 DB to a SQL 2005 DB. The SQL 2005 DB is being used for reporting only. I have noticed that the indexes have not come over with the tables.

    When I initially set up to do the table copy, I used the Import and Export Wizard in SSMS. I am thinking now that this is not the best solution.

    Thanks.

  • December 12, 2008 at 10:52 am

    #911811

    Is this a whole database or a table, if its a database then why not backup and restore 🙂

  • December 12, 2008 at 12:14 pm

    #911866

    Then that would involve a FTP transfer to the other server and I think our network has blocked ftp transfers, I have discovered a database copy in SQL 2005. I was planning to try that tonight.

  • December 15, 2008 at 3:10 pm

    #912833

    I attempted to do a database copy and it failed. It said there was not enough disk space. That is odd considering I know that the table file (.mdf) is approx. 12GB and the drive I am putting it on has just over 24GB free.

    Is there a certain amount of space needed on the C: drive (~2.5 GB free).

    Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply