Educational Software Thread, SQL Server Express for ICT students in Technical; I've had a request from one of the 6th form ICT students, via his ICT teacher, to have SQL Server ...
19th July 2010, 10:51 AM #1
SQL Server Express for ICT students
I've had a request from one of the 6th form ICT students, via his ICT teacher, to have SQL Server Express installed on all the ICT machines, as they apparantly need it.
My question is, do they? We currently have Visual Studio 2008 (to be upgraded to 2010 over summer) and I'm sure that it included some sort of basic SQL server for use in development? (to be fair we may not have installed it) Would that be enough?
Just not really sure I want 60+ SQL servers on our network. If the above is incorrect, would a single server that students could put their databases on be better?
19th July 2010, 10:59 AM #2
Set it up in a single instance on a server and create a database for each student on it.
19th July 2010, 11:00 AM #3
Server instance would be far better.
Your argument for this is that if kids move around they might fancy keeping their databases.
19th July 2010, 07:24 PM #4
If you've done a full install of Visual Studio 2008 (or 2010) then you will have SQL installed.
I'd definitely recommend putting it on a server for the students to use. You need to find out exactly what they're wanting to do. If they need to be able to create databases (which is quite reasonable) then you may be better having multiple instances (name them with the student usernames??) because you can then make the student the owner of the databases and they can't accidentally or deliberately mess up other people's work.
If they're just going to create/modify/delete tables then giving them each a database on the same SQL server should be fine.
19th July 2010, 07:26 PM #5
Server instance once again. No need for each child to have there own individual databases when a server instance will easily cover all of there needs.
By localzuk in forum Windows Server 2000/2003
Last Post: 30th April 2010, 02:27 PM
By damienharrison in forum Windows Vista
Last Post: 13th March 2009, 12:26 PM
By cheredenine in forum MIS Systems
Last Post: 19th December 2008, 07:42 PM
By Michael in forum Windows
Last Post: 21st May 2008, 06:09 PM
By contink in forum Windows
Last Post: 14th May 2008, 03:56 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)