Migrate from MS Access to SQL Server 2005 database从MS迁移访问SQL Server 2005数据库
Posted on September 16, 2008 at 5:39 am发布于08年9月16日在上午05点39分
Recently, I had to migrate the data from an Access database to SQL Server 2005 because my database was getting too large for Access to handle.最近，我不得不迁移数据从一个Access数据库到SQL Server 2005 ，因为我的数据库是太庞大的访问来处理。 I decided that since it’sa fairly simple process, but something that many people might be doing, that I would write it up here as an article.我决定，因为这是相当简单的过程，但有很多人可能会做，我将它写在这里的一篇文章。
I’ve also written two other migration articles that you might be interested in:我也写了两其他移民的条款，你可能会感兴趣的： Migrating pictures from Flickr to Picasa迁移来自Flickr照片到Picasa and和 migrate from iPhone to iPhone 3G从iPhone移植到iPhone的3G . 。 Now back to Access to SQL.现在回到取得的SQL 。
First, you need to make sure you have SQL Server 2005 or SQL 2005 Express installed on your computer along with the SQL Server Management Studio.首先，你必须确保你的SQL Server 2005或SQL 2005 Express的计算机上安装与SQL Server Management Studio中。 If so, you’re ready to export your Access database to SQL 2005.如果是的话，您准备好您的出口Access数据库到SQL 2005 。
Transfer Access database to SQL Server 2005 Access数据库迁移到SQL Server 2005
Open SQL Server Management Studio and connect to the database server you want to import your Access database into.打开SQL Server Management Studio中，并连接到数据库服务器要汇入您的Access数据库到。 Under Databases , right-click and choose New Database .根据数据库 ，右击，并选择新的数据库。
Give it a name and configure the other settings as needed and click OK.给它一个名称和配置其他所需设置，然后单击确定。 Now we need to right-click on the database we just created and choose Tasks and then Import Data .现在我们需要右击数据库，我们刚刚建立，并选择任务 ，然后导入数据 。
On the Data Source dialog box, scroll up until you see Microsoft Access .在数据源对话框中，滚动，直到你看到的Microsoft Access 。
Next to File, click on Browse and navigate to the Access database you want to import and click Open .旁边的文件，点击浏览并浏览到Access数据库要导入并点击打开。 Note that the database cannot be in Access 2007 format as SQL Server 2005 does not recognize it!请注意，数据库不能在Access 2007格式的SQL Server 2005不承认它！ So if you have a 2007 Access database, first convert it to the 2002-2003 Access format by going to Save As.所以，如果你有一个2007年的Access数据库，首先转换为2002-2003访问格式去保存。
Go ahead and click Next to choose the destination.往前冲，然后单击下一步，选择的目的地。 Since you right-clicked on the database you wanted to import the data into, it should already be picked in the list.由于您的权利，点击数据库你想将数据导入到，现在应该已经选择在清单中。
Click Next and then specify how you want to transfer the data from Access to SQL by choosing either Copy the data from one or more tables or Write a query to specify the data to transfer .单击下一步，然后指定您要如何转移的数据存取到SQL通过选择或者复制数据从一个或多个表或收件查询指定的数据传输 。
In most cases, if you want to just transfer the entire database, you should choose the first option.在大多数情况下，如果你想转让只是整个数据库，您应该选择第一种选择。 If you want only a portion of the data from a particular table, you can write out the SQL query.如果你想只有部分的数据从一个特定表，你可以写出来的SQL查询。 Click Next.单击下一步。
By default all the tables should be selected and if you click the Edit button under Mapping , you’ll see the the destination database will create all of the tables to match what’s in the Access database.默认情况下，所有表格应选择，如果您单击编辑按钮映射下，您会看到在目标数据库将创建的所有表匹配的Access数据库中。
Here I have only one table in my Access database.在这里，我只有一个表在我的Access数据库。 Click Next and then choose whether to execute immediately or to save it as a file to perform later. 单击下一步，然后选择是否要立即执行，或将其保存为一个文件后执行。
Click Next and then click Finish . 单击下一步，然后单击完成。 You’ll then see the progress of the data transfer as it occurs.然后，您将看到的进展，数据传输，因为它发生。
After it is completed, you’ll see the number of rows transferred for each table in the Message column.之后完成后，您会看到的行数为每个移交表中的信息栏。
Click Close and you should now have all of your Access data nicely imported into a SQL Server 2005 database, which you can then use for whatever you like.单击关闭，你现在应该有所有的访问数据很好汇入SQL Server 2005数据库，您就可以使用任何您喜欢。
Any problems importing your data from Access to SQL 2005?任何问题汇入您的数据存取到SQL 2005年？ If so, post a comment and I’ll try to help!如果是这样，后一个评论，我会尽力帮助！
» Filed Under »文章属于 MS Office Tips的MS Office秘诀
 Save this page 保存该网页 |  Stir it up on Mixx 它搅动了Mixx | |
 Add to Reddit 添加到Reddit |  Stumble this page 失败此页 |
Related Posts 有关职位
- Excel Basics - How to use the Conditional Sum wizard Excel的基本知识-如何使用条件求和向导
- How to map a drive in Windows如何将一个驱动器映射在Windows
- Page Saver - Free FireFox extension to capture images of web pages网页保护-免费的F irefox扩展到捕捉图像的网页
- How to burn Windows Movie Maker WMV video to DVD如何烧伤的Windows Movie Maker WMV视频到DVD
- First look and review of Microsoft Office Live Workspace Beta首先外观和审查微软Office Live测试工作
