Hi. I am trying to migrate an MS Access 2003 database to MS SQL Server 2005, using the Microsoft SQL Server Migration Assistant for Access.
I have used the Migration Assistant successfully in the past.
Now, however, when I create a migration project, Add the database, connect to my MS SQL Server, and try to "Convert, Load, and Migrate" the MS Access 2003 database, I get an error:
"There is nothing to process."
The migration assistant will not convert, load, or migrate my database. Apparently the Assistant does not recognize or see the database?
A few months ago, jmoss111 very kindly helped me with this exact problem:
https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24322709.html
jmoss111 fixed the migration problem, but says that he had to "jump through hoops to do it including removing and creating indexes; copying, deleting, and renaming tables, and dropping sub datasheets".
Can someone tell me what I am doing wrong? Why does my Access 2003 database require all of these modifications before it will cooperate with the Microsoft SQL Server Migration Assistant for Access?
I do not see any subdatasheets in this database. There are six tables, unrelated. It's a very simple database. Six tables; each has data; but nothing complicated.
I'm really grateful for any help or ideas. I need to migrate this data ASAP.
Thanks so much.
Eric