迁移访问SQL Server 2012 [英] Migration Access to SQL server 2012

问题描述

对于一个项目，我需要将Access数据库迁移到SQL Server 2012 Express，我发现了一些实现此目的的方法，例如使用Microsoft升迁，但是这个问题不是技术性的，只是寻找替代方法，访问中的数据库包含机密数据，因此我不允许查看数据，我想确定是否有任何程序对我无需查看数据库本身以及如何验证数据正确无误即可实现迁移两个都.我没有数据库背景，因此特定的指导和资源很有用. 我不知道如何搜索特定方法(用于迁移)，所以给我扔一些方法，这样我就可以继续我的研究.(

For an project, I need to migrate an Access database to SQL server 2012 express, I found some ways to do this, like using Microsoft up-sizing, but this question is not very technical but just to find out alternative ways, the database in access contains confidential data, so im not allowed to see data and I want to find out is there is any procedure that can be useful for me to achieve migration with out seeing the database itself and how to verify the data is exact in both. I don't have database background so specific directions and resources is useful. I don't know how to search for specific methods(for migration) so throw me some methods so i can continue my research.(

数据库:Access 2007目标:SQL Server Express2012.是否有任何工具 在SQL Server 2012中实现此目标?如何检查数据(表格， 查询，关系，数据本身是否正确迁移以及如何迁移 处理数据格式问题)而看不到数据(不允许)Im 寻找一种自动方式.

DB: Access 2007 target: SQL server express 2012. IS there is any tool in SQL server 2012 to achieve this? How to check the data(tables, query, relationships, data itself are migrated correct and how to handle data format issues) without seeing the data (not allowed) Im looking for an automatic way.

感谢您的帮助和考虑

推荐答案

Microsoft为Microsoft Access 97和更高版本提供了到SQL Server 2005-2012和Azure的迁移助手.请参阅 http://www.microsoft.com/en-us/download/confirmation.aspx?id = 28763 .

Microsoft provides a migration assistant for Microsoft Access 97 and higher to SQL Server 2005-2012 and Azure. See http://www.microsoft.com/en-us/download/confirmation.aspx?id=28763.

这篇关于迁移访问SQL Server 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！