MS Access应用程序-将数据存储从Access转换为SQL Server [英] MS Access Application - Convert data storage from Access to SQL Server
问题描述
请记住，我不是Access专家.我精通SQL Server和.Net框架.这是我的情况:
Bear in mind here, I am not an Access guru. I am proficient with SQL Server and .Net framework. Here is my situation:
承包商为我的公司构建了一个非常大型的MS Access 2007应用程序.
A very large MS Access 2007 application was built for my company by a contractor.
该应用程序已按访问权限分为两层；有一个前端部分保存所有Ms Access表单，然后在后端部分保存访问表，查询等，这些表单存储在网络上的计算机上.
The application has been split into two tiers BY ACCESS; there is a front end portion that holds all of the Ms Access forms, and then on the back end part, which are access tables, queries, etc., that is stored on a computer on the network.
当然，有必要将数据存储部分转换为SQL Server 2005，同时保留所有在ms女士中内置的GUI表单.这是我进来的地方.
Well, of course, there is a need to convert the data storage portion to SQL Server 2005 while keeping all of these GUI forms which were built in Ms Access. This is where I come in.
我已经阅读了一些，发现可以将表格甚至访问表链接到SQL Server表，但是我仍然不确定到底可以做什么以及如何做.
I have read a little, and have found that you can link the forms or maybe even the access tables to SQL Server tables, but I am still very unsure on what exactly can be done and how to do it.
有人这样做吗?请评论有关此任务的任何功能，限制和注意事项.谢谢！
Has anyone done this? Please comment on any capabilities, limitations, considerations about such an undertaking. Thanks!
推荐答案
请勿使用Access中的升迁向导:
Do not use the upsizing wizard from Access:
-
首先，它不适用于SQL Server 2008.
First, it won't work with SQL Server 2008.
第二，有一个更好的工具可以完成这项工作:
SSMA，用于访问的SQL Server迁移助手由Microsoft免费提供.
Second, there is a much better tool for the job:
SSMA, the SQL Server Migration Assistant for Access which is provided for free by Microsoft.
它将为您带来很多帮助:
It will do a lot for you:
- 将数据从Access移至SQL Server
- 自动将表链接回Access
- 为您提供了有关两个数据库中存在的潜在问题的大量信息
- 保留更改的跟踪信息，以便在迁移完成之前使二者保持同步.
我写了博客条目关于它.
这篇关于MS Access应用程序-将数据存储从Access转换为SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
