We help IT Professionals succeed at work.
Get Started

Microsoft SQL Server Migration Assistant for Access Problem -- "There is nothing to process"

868 Views
Last Modified: 2012-05-08
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
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE