Title says it all. I want to copy the data from an existing Access 2000 database to an existing Sql Server 2008 database. I would prefer to have the ability to only copy some data, so that I may add constraints (like ON CASCADE DELETE) as I go.
Any ideas?
There is a free application provided by Microsoft called SQL Server Migration Assistant (SSMA) 2008 for Access V4.0:
Microsoft SQL Server Migration Assistant (SSMA) 2008 for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2008. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server. SSMA for Access supports Access 97 - Access 2007 databases.