将数据从Access导入到SQL Server（具有小表更改） [英] Importing data from Access to SQL Server (with minor table changes)

问题描述

我目前正在将应用程序从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

这篇关于将数据从Access导入到SQL Server（具有小表更改）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！