MS Access


Can I migrate my data from a Microsoft Access database to a Microsoft SQL Server database?
Yes, there are tools available for facilitating the transfer of tables and data to SQL Server. These tools greatly reduce the amount of time necessary for migrating from an Access database to a SQL Server database. Because SQL Server is does not have any direct form building capabilities you will still need Microsoft Access or another form building platform (Microsoft .NET Windows forms, ASP.NET web forms, etc.) to display and edit the SQL Server data. In addition, there is support for migrating Microsoft Access database reports to SQL Server Reporting Services which greatly reduces the costs of migrating reports to SQL, if this is a requirement.