Migrate Access database to MS SQL server (2005)

Discussion in 'Databases' started by oZone, Nov 25, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi
    I am trying to migrate an access database with the Microsoft tool "SQL Server Migration Assistant for Access". I have migrated one table with success, but the other seem to get an error message in consol:

    StatusFrom TableTo TableSource Row CountTarget Row CountRatioError Messages
    ObjectNotExistsInTargetglobal: sitesSQL2005_278066_seopublish.dbo.[sites]N/ATarget table 'SQL2005_***.dbo.[sites]' is not accessible. Make sure the table has been converted and loaded into SQL Server.;

    The meta data explorer shows all tables, but still it gives me that error.

    Can anyone give me a hint? Or: Is there any other way to migrate it that will work better?

    Regards,
    Øystein, Norway
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    What is"SQL Server Migration Assistant for Access"?

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. Bruce

    Bruce DiscountASP.NET Staff

    hmmm.. haven't play w/ this before.


    We'll give it a quick test.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page