将访问表迁移到SQL Server-初学者 [英] Migrating Access Tables to SQL Server - Beginner

问题描述

我正在Access 2007数据库中工作，需要帮​​助将表迁移到SQL Server.仅购买Access 2007就能做到吗?还是需要为SQL下载单独的程序?当我尝试创建一个新的SQL数据库或通过Access打开一个现有的SQL数据库时，出现"CREATE DATABASE"或"CREATE TABLE"错误，并且不确定是什么问题.任何建议将不胜感激！

I'm working in an Access 2007 database and need help migrating tables to SQL server. Is this possible to do having only purchased Access 2007 or do I need to download a separate program for SQL? When I try to create a new SQL database or open an existing one through Access, I'm getting a "CREATE DATABASE" or "CREATE TABLE" error and not sure what the issue is. Any advice would be greatly appreciated!

推荐答案

是的，您需要安装它.有一个免费的SQL Server版本，称为 Sql server express .数据库大小限制为4gb.如果适合您，那就去吧.另外，我相信Access内置了迁移工具.

Yes, you need to install it. There is a free edition of SQL Server, called Sql server express. Database size limit is 4gb. If it suits you go for it. Also, i belive Access has migration tool built in.

更新:在Access 2007中-数据库工具->移动数据-> Sql Server(遵循向导).

Update: In Access 2007 - Database Tools -> Move Data -> Sql Server ( follow the wizard ).

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