Solved

SQL / .NET Framework Question

Posted on 2007-03-27
6
207 Views
Last Modified: 2013-12-17
I want to use a SQL database for an application I'm writing.  It was using an Access database, but the database will eventually collapse (a fairly long time from now) because the size will eventually be too large for an Access database.   So, we want to move over to SQL before that happens.  Originally, the usage was that there was a database of x-rays with all the identifying information.  The software just read out of that database to open selected x-rays.  We just want to make that Access database into a SQL database.  However, I've never used SQL before.  I started writing code in MSVS C# 2005 Pro edition using the .NET Framework and the System.Data.Sql namespace.  Now, if I write code with that, will each client computer now have to have an SQL Server on their system?  The application will be the only thing accessing that database and it'll never be accessed over the network.

So, the main question is, "will an installation of a SQL server be absolutely required on each client system with the application?"  If I do need a SQL Server installed on each machine, would I be allowed to install MS Sql Server 2005 Express edition on each machine or would that be against the licensing (i never understand EULAs)?

A secondary question is just asking if anybody knows of any good references for using the System.Data.Sql namespace to write a project and also any good references for anything else related to SQL that I should know.
0
Comment
Question by:raw_enha
  • 3
  • 2
6 Comments
 
LVL 16

Expert Comment

by:rboyd56
ID: 18800091
SQL Server does not need to be installed on each system. You can have each client machine access a remote SQL Server which will store the data in a central location.

However, if the clients will be disconnected at times from the network or if they need to make updates to a separate database than the central server then it might be best to install SQL Server Express on the client machines.

It really depends on the architecture of the application.

But as a general rule all clients can access the same SQL Server as the backend of the application.
0
 

Author Comment

by:raw_enha
ID: 18800223
We don't want everyone to access it centrally.  We want them all to have their own SQL DB on their computer.  Not all of them have internet access.  This is for an application that gets sold to the user.  We needed something better than an Access database though.
0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18800284
Then yes you will need to install SQL Server on each client. SQL Server Express will work for this. It is basically what it is designed for.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:raw_enha
ID: 18801213
We build the computers before hand for the customer.  So, it will be legal for us to install SQL Server 2005 Express on there before giving them the computer?
0
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18801522
If you are shipping an application that uses SQL Server Express on it I would assume so. SQL Server Express is freely distributable with an application developed in Visual Studio 2005 that uses SQL Server Express.
0
 

Expert Comment

by:climberboy
ID: 18803418
rboyd56 is correct.  Use the Express Version, and make it a dependancy in your application setup project.  It will install automatically when the user installs your application.

For ADO.Net / SQL, use enterprise library.  It's very well thought-out, and you can get a grip on how it works without too much effort.

If you need, email me at eric@pixelninjas.com and I will send you some sample N-Tier code to manage your DAL, BLL, and Front end.

Thanks,

Eric.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question