我想从访问切换到SQL [英] I want to switch from access to sql

问题描述

大家好

我开发了一个小的vb .net应用程序供朋友在他们的业务中使用。我使用Access作为数据库，非常容易使用。但是现在我想从访问sql升级数据库。请帮助我



如果我的客户端不想在他们的电脑上安装高端SQL服务器那么我应该使用什么。有没有可移植的sql访问权限。我已经看过sql compact这样的数据库是怎么回事，如果好的话怎么用呢请帮帮我。

Hi everyone
I have developed a small vb .net application for friend to use in their business. I have used Access as the database which is quite easy to use. But now I want to upgrade the database from access to sql. Please help me

And if my client does not want A high-end SQL-server on their pc then what should I use. Is there any sql like access which is portable. I have seen database such as sql compact how is it and if good then how to use it please help me out.

推荐答案

你好b $ b

您可以非常轻松地将访问数据库转换为SQL Server，在SQL Server中使用导入选项，您只需要在SQL Server中创建新数据库，然后可以使用导入数据库选项，这些链接可以使用完整;）



http://office.microsoft.com/en-us/access-help/import-or-link-to-sql-server-data-HA010200494.aspx [ ^ ]

http://support.microsoft.com/kb/237980 [ ^ ]


为了便携性，您可以使用SQL Server Express Edition但是您需要在目标机器上安装sql server;）

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx [ ^ ]

最好的问候。

Hi
You can convert your access database into SQL Server really easily, With Import option in SQL Server, you just need to create new database in your SQL Server and after that you can use Import Database option, these links can be use full ;)

http://office.microsoft.com/en-us/access-help/import-or-link-to-sql-server-data-HA010200494.aspx[^]
http://support.microsoft.com/kb/237980[^]

And for the portability you can use SQL Server Express Edition however you need to instalation sql server on target machine ;)
http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx[^]
Best Regards.

我们无法帮助您升级数据库。



For您的问题的第二部分将查看此比较 http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems [ ^ ]



有关如何操作的说明使用您选择的任何一个参考供应商的网站

We can''t help you with upgrading the database.

For the second part of your question have a look at this comparison http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems[^]

For instruction on how to use whichever one you choose refer to the supplier''s website

您好b $ b

最近做了类似的事情（但你不要如果您需要在每个工作站上使用数据库，或者如果您在网络服务器上使用中央数据库，请说。）



我安装了SSE2008R2（SQL Server 2008 R2 Express） （免费）在他们的服务器上。



我使用SSMA（Sql Server Migration Assistant for Access）将Access数据库迁移到SQL服务器 - 效果非常好。 />


还安装了SSMS（SQL Server Management Studio）来管理SSE数据库。



你可能还想要考虑一下他们如何进行备份 - 在我的例子中，他们只是简单地获取了db.accdb文件的副本。 SSE DB的备份显然有点不同



我在我的（非常低端）笔记本电脑上运行SSE - 它很好！所以我不会强调这一点。

Hi
Recently done a similar thing (But you don''t say if you need a database on each workstation, or if you are using a central Database on a network server.)

I installed SSE2008R2 (SQL Server 2008 R2 Express) (Free) on their Server.

I used SSMA (Sql Server Migration Assistant for Access) to migrate the Access database to the SQL server - works very nicely.

And Also installed SSMS (SQL Server Management Studio) to manage the SSE database.

You may also want to give some consideration as to how they do backups - in my case they were simply taking copies of the db.accdb file. Backup of an SSE DB is obviously a bit different

I''m running SSE on my (very low end) laptop - and its fine! So I wouldn''t stress about that.

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