Import Access to SQL Server using Microsoft SQL Server Migration Assistant for Access
Posted on 2012-03-11
I have an ASP.NET website that pulls data from a Microsoft Access 2010 database. The website was working fine, but now with the increased number of hits I need to upgrade the Access 2010 database to Microsoft SQL Server 2010.
I have installed the Microsoft SQL Server Migration Assistant for Access; however, I am not quite sure how to use it. Can anyone give me a brief tutorial to migrate Access 2010 to SQL Server using this tool?