I am using Microsoft SQL Server Migration Assistant v6 (aka SSMA) to update a database from Access to SQL Server. I am getting informational messages that say "A2SS0029: Index name 'Name' was changed during conversion.".
As these are just index names, that shouldn't cause a problem for me. But I do wonder why the name has to be changed. Particularrly since I was able to create an index with the given name manually after the migration.
Why are the index names being renamed? And am I wrong about that not causing any problems (given that I don't have any queries that use index hints, if that is even possible with Access).
Asked by jmoreno
(1097 rep)
Jan 15, 2015, 09:04 PM
Last activity: Jan 16, 2015, 01:35 AM
Last activity: Jan 16, 2015, 01:35 AM