none
Migration Assistant Access to SQL Server problems

    Вопрос

  • I would like to migrate an Access 2003 .mdb to SQL Server 2008 R2 using the migration assistant.

    I did the following in the 'Microsoft SQL Server Migration Assistant Wizard for Access':

    Selected Migrate to SQL Server 2008 (there is no option to select SQL Server 2008 R2), accepted the default location. I then added the database. In the next page, I ticked all the boxes.

    If I drag over the .mdb, I get this message (see below):

    I then created a new database, ticked link tables so that it links to the current .mdb as a front end and then got this error msg:

    and then got msg's that the operation failed.

    I am not sure what to do next. I don't know if installing this will make a difference as I missed it out of the procedure: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=10910 or if this is another issue.

     
    • Изменено meridius10 5 марта 2012 г. 17:40
    5 марта 2012 г. 17:36

Все ответы