SQL Server Migration Assistant (SSMA) Team's Blog

How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure

Auto generate link table when migrating access database using SSMA

Auto generate link table when migrating access database using SSMA

  • Comments 1

[Updated: 2/9/2012 Selina Jia]

SSMA provide an option to automatically create a link table for every table it moves to SQL Server. This is a useful functionality to allow all forms, reports, and query that refers to the table still work after the data move to SQL Server.

You can select the option to create link table from the migration wizard as follows:

SSMA_Wizard_linkTable

Or you can select a specific table, right click and choose “Link Table” from the menu

SSMA_CreateLinkTable

Note that this functionality is only supported with you connect to SQL Server by specifying the actual server name. If you use “localhost” as servername, you may receive the following error message:

Connection failed: SQL State: ‘08001’ SQL Server Error:17 [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exit or access denied.

SSMA_linkTableError

To resolve the error, you can reconnect to SQL Server and specify the server name (or your machine name in the case of localserver).

SSMA_Reconnect

[Updated: i am not sure the example uses which build, but i use SSMA 5.2 to test it, it will link succeed even though using “localhost” as servername:

]

  • English could be better.

    Which versions of Access are supported is not menioned.

    What does (mentioned elsewhere) compatible with all previous versions mean (with reference to SQL Server)? Does it mean if an Access 2000 based system is working with SQL Server 2000, it will work without a sibgle change with SQL Server 2008 ?

    Skand@softoolsme.com

Page 1 of 1 (1 items)
Leave a Comment
  • Please add 3 and 2 and type the answer here:
  • Post