I want to switch from access to sql

Question

0.00/5 (No votes)

See more:

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.

Posted 25-Apr-13 2:56am

Kashif Alvi

Add a Solution

Comments

[no name] 25-Apr-13 9:01am

"Please help me".... with what?

3 solutions

Solution 1

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

Posted 25-Apr-13 3:00am

CHill60

Solution 3

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.

Posted 3-May-13 16:54pm

Richard.Berry100

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aydin Homay · Accepted Answer · 2013-04-29T00:31:00

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.