Microsoft SQL Server Migration Assistant (SSMA) is a toolkit for quickly and easily converting Access Databases to full fledged SQL Server Databases. Exactly what I was looking for to move my newly created 2010 Census Access Database to someplace more usable for my purposes.
Download the toolkit at: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=959
And thanks goes out to the Access Team over at the Access Blog for pointing me to the right place thanks to a wonderful Bing search.
Here’s the installation of that tool…
I have plenty of space and do not like to go back and reinstall things I need… so I’ll do a complete installation.
That’s it… checkout my next article where I describe using it to actually migrate Access data to my SQL 2008r2 server.
If you have any questions or comments, please leave them below!
One thought on “Microsoft SQL Server Migration Assistant for Access”