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!