locked
Access DB to SQL migration RRS feed

  • Question

  • Hi All,

    While i m trying to migrate the access DB to SQL server through SSMA. The migration is successful but it leaves some unknown informations or website symbols or temp DB(screen shot ).

    Can some one tell me what is that?

    Regards


    K.G.Manivannan

    Thursday, November 21, 2013 5:32 PM

Answers

All replies

  • Hi kcgmani,

    According to your screenshot, in access, the migrated tables are displayed with a blue-green globe. The original tables have been renamed using the format SSMA$<tablename>$local.

    For more information about How to use SSMA to migrate data from Access to SQL Server , you can review the following blog.
    http://blogs.msdn.com/b/ssma/archive/2011/01/29/access-to-sql-server-migration-how-to-use-ssma.aspx

    Thanks,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by kcgmani Friday, November 22, 2013 9:22 AM
    Friday, November 22, 2013 6:46 AM
  • HI Sofiya,

    Thanks again. I have disabled the option of linking the tables (source DB to Destination DB).

    Is that the only way to avoid the globe being formed &renaming of the access Tables? If there is another way..Please let me know.

    The reason behind is once the tables are renamed-metadata is getting affected and i am unable to us ethe same access tables to migrated into other sql servers.

    the scenario remains the same(meta data impacts) even if the globe forms.

    Regards,

    Manivannan


    K.G.Manivannan

    Friday, November 22, 2013 9:25 AM