SSMA doesn't show tables for conversion

Dominik Reinisch 0 Reputation points
2023-04-18T07:32:35.01+00:00

I was using the MS SQL Server Migration Assistant to migrate a MS Access DB to an SQL Server. When i tried it the last time, it ran into problems and didnt transfer all the necessary Data. But now, if i want to run it again, it wont even show me the Tables in the treeview to select for Conversion. how can i fix this, or is there another Method to efficiently transfer the Access DB to an SQL Server.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,893 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,451 Reputation points
    2023-04-19T06:08:47.7766667+00:00

    Hi @Dominik Reinisch ,

    Sometimes, restarting the migration assistant can help resolve temporary issues.

    In addition you are still with something to do.

    Check the Access database connection: Make sure that the Access database file (.mdb or .accdb) is accessible and that you have the necessary permissions to read from it. Verify the connection settings in the Migration Assistant to ensure they are accurate.

    Check the SQL Server connection: Verify that you have a valid connection to the SQL Server. Ensure that the SQL Server is running, and you have the necessary permissions to create a database and transfer data to it.

    Check for error messages: The Migration Assistant may display error messages or warnings in the log or output window. Check for any error messages or warnings and take appropriate actions to resolve them.

    Best regards,

    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it.

    0 comments No comments