Hi,
I am new to Microsoft Access (and located near you in Rockville, Maryland) and have a computer consulting question. I wonder if I can migrate my data from a Microsoft Access database to a Microsoft SQL Server database. Do you have any experience with this?
Thanks.
Yes, there are certainly 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 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.
CCD has extensive experience with Microsoft Access, SQL Server, and transforming from one to the other. Contact us for a free discussion of your situation!