Is there an easy way to export the backend of an MS Access database (tables and relationships) to a SQL Server database so that it can then be used as a backend for a custom application written in C # using the Entity Framework?
Access database contains at least 50 tables, and export should not destroy its structure and relations.
Microsoft SQL Server Migration Assistant for Access
, SSMA - , Access. Front Access, , , , VBA, SQL Server. , .
, . , . Access.
Microsoft SSMA 2010 , NOT . , MS SSMA.
There is an Upsizing Wizard for access to migrate to MSSQL 2008. Go to the [Database Tools] menu and click the [SQL Server] icon, then migrate using the wizard.