title: Copy table data from SQL Server 2000 to SQL Server 2008
body: <p>I have a SQL Server 2000 database with 7 tables. I want to copy the table data from this database to another database running on a SQL Server 2008 instance.</p>
  
  <p>The tables will be exactly the same, I just need to copy the data from one to another.</p>
  
  <p>Edit:</p>
  
  <p>I get the following errors when trying to import from SQL Server 2008, I even check the box drop destination tables.:</p>
  
  <blockquote>
    <p>Validating (Error)<br>
    Messages<br>
    Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "AllowedHtmlSystemID".<br>
    (SQL Server Import and Export Wizard)</p>
    
    <p>Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.<br>
    (SQL Server Import and Export Wizard)</p>
    
    <p>Error 0xc004706b: Data Flow Task 1: "component "Destination 1 - DnnBBAllowedHtml" (79)" failed validation and returned validation
    status "VS_ISBROKEN".<br>
    (SQL Server Import and Export Wizard)</p>
    
    <p>Error 0xc004700c: Data Flow Task 1: One or more component failed validation.<br>
    (SQL Server Import and Export Wizard)</p>
    
    <p>Error 0xc0024107: Data Flow Task 1: There were errors during task validation.<br>
    (SQL Server Import and Export Wizard)</p>
  </blockquote>
  
  <p>EDIT:</p>
  
  <p><img src="https://i.stack.imgur.com/dEQPK.png" alt="enter image description here"></p>