Post reply

ACCESS to SQL

  • February 19, 2004 at 1:25 pm

    #82320

    Hello.

    I want to use Enterprise Manager to import ACCESS into SQL.

    I noticed that the tables lose their keys (Primary and Foreign)

    when they end up in SQL.

    Any thoughts ?

     

  • February 19, 2004 at 1:43 pm

    #494786

    Import wizard will only transfer data from Access to SQL Server. You have to rebuild the keys and indexes manually.

    You can use Access Upsize wizard to migrate the Access database to SQL Server and it will upsize the primary key / foreign keys, indexes and maintain the relationship.

Viewing 2 posts - 1 through 1 (of 1 total)

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