SQL Server 2005 Migration Assistant Autonumber problem.

Discussion in 'MCTS' started by LarryWestMCSD, Mar 24, 2007.

  1. I am trying to migrate an Access 2003 database to SQL Server 2005 using the
    SQL Server Migration Assistant for Access and am having various problems:

    1. On one table, the migration gives the following on an autonumber field:
    A2SS0023: SQL Server Migration Assistant for Access Warning Message: Default
    value '0' added to target column (1), followed later on by
    A2SS0028: Auto-increment attribute of the column 'MSEQ' was not converted to
    Identity because the column has a default value.

    This table has about 80,000 records.

    2. If I include another table in the migration, this one with 3.4 million
    records (hence our need to upgrade to SQL server 2005), I am getting a
    timeout error, even when I try to migrate the table by itself. I have
    verified that all timeout options are set to zero (unlimited time).

    Any suggestions would be appreciated.

    -- Larry J. West, MCSD, MCPD, MCTS: SQL Server 2005 [so yes, I should know
    the answer to this, but I don't], MOUS, FLMI, ACS
    LarryWestMCSD, Mar 24, 2007
    1. Advertisements

  2. Sorry, we don't have 2000, only 2005.
    I assume the reason it doesn't work is that Access 2003 isn't compatible
    with 2005 since it came later, and running the upsizing wizard didn't work
    Is there a free version of 2000 anywhere that I can temporarily download and
    Larry J. West, MCSD, MCPD, MCTS:SQL Server 2005, MOUS, FLMI, ACS

    LarryWestMCSD, Mar 28, 2007
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.