Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

General Database Question

 
ServiceCenter
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am new to database programming and I was curious on exactly what SQL Server does as opposed to access. Does SQL Server store all of the records itself, or is it merely an engine to manipulate a database. If someone could give me a general overview of what SQL server does, it would be a big help. Thanks.
 
Daniel Dunleavy
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Access was created as a 'user database' which would be simple to use. It doesn't have the speed or locking capabilities of a full blown database. You don't hear a lot of datawarehousing projects running their terabytes through an access database do ya?
Its OK for small projects.
Dan
 
ServiceCenter
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So SQL Server runs completely independently of access? Could i use a perl script to update a sql server database using forms on the web?
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"ServiceCenter",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.
Thanks.
 
rani bedi
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
try this link
http://www.swynk.com/friends/Vartanyan/Access_vs_SQLServer.asp
 
Andrew Levine
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Great, thanks.
 
Andrew Levine
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does anyone here know any other places where i can answert questions on access vs. sql server?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic