Issue with using SSMA Tool to Migrate a table from Access to SQL Sever
Posted on 2006-10-28
I am using the SSMA - SQL Sever Migration Assistanct for Access to migrate my Access 2003 database to SQL Sever. Everything is working perfectly and so far have no problems and I am migrating multiple database. However I noticed that one table called tblPersonnel from one of the access database converted its schema to SQL, loaded to the target database but will not migrate its data. In the log report that appears after i go to migrate the table shows no errors only that the row count completed is 0 instead of the correct row count. Normally there is an error and what it causing the problem in the log file but nothing.
This is the only issue i am getting. All the other tables migrated perfectly. Has anyone got any ideas as to why this might be happening?
Thanks in advance for all the help.