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測試工作
