将数据从Access导入到SQL Server（具有小表更改）
我目前正在将应用程序从MS-Access迁移到MS SQL Server。在此过程中，我对表布局进行了一些小的更改（我将几个事件分成更多的两个表），但是，我仍然想保留数据库中存在的所有数据。
I'm currently working on migrating an application from MS-Access to MS SQL Server. In the process, there are a few minor changes that I am making to the table layouts (I am splitting a few things up into more two tables), however, I would still like to keep all the data that is present in the database.
在更改数据库结构以适应我的新需求时，最好的方式是导入数据？
What would be the best way to import the data, while changing the database structure to suit my new requirements?
如果您计划将Microsoft Access数据库升级到SQL Server 2008，请使用SQL Server迁移助手（SSMA），而不是MS Access中内置的升级向导。
If you are planning to upgrade a Microsoft Access database to SQL Server 2008, use the SQL Server Migration Assistant (SSMA) rather than the upsizing wizard built into MS Access.
从这里下载（感谢Tony）： SQL Server Migration Assistant 2008 for Access
Download from here (Thanks Tony): SQL Server Migration Assistant 2008 for Access