Export MS Access Database to SQL Server 2008 Express

export, ms-access, sql

Solution

Microsoft SQL Server Migration Assistant for Access

Problem

Is there an easy way to export a MS Access Database backend (Tables & relations) into an SQL Server database, so that it then can be used as a backend for a tailored application written in C# using Entity Framework? The Access Database contains at least 50 tables and the export should not ruin its structure and relations.

Original source