I've got an Access database from one of our clients and want to import this data into a new MSSQL Server 2008 database structure I designed. It's similar to the Access Database (including all the columns and so on) but I normalized the entire database.
Is there any tool (microsoft tools preferred) to map the old database to my new design?
thanks