Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mercury76
Starting Member
7 Posts |
 Posted - 2007-10-09 : 23:50:19
|
| hi guys,im new to sql server...i am currently studying sql server 2000i know this subject has been asked before... i would just like to ask if you know some related articles regarding advantages of using sqlserver over vfp dbf/dbc?i am going to discuss it to my class.thanks very much!any help is very much appreciated!Joel |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-10 : 00:12:41
|
| SQL Server is a relational database. VFP ... errmmm .... isn't.Its like chalk and cheese ... |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-10-10 : 01:38:25
|
also, why study SQL Server 2000? it will be deprecated soon. I'd start with 2005 if I were you.
elsasoft.org |
|
|
|
mercury76
Starting Member
7 Posts |
Posted - 2007-10-10 : 02:28:32
|
thanks kristen,actually ive seen some matters regarding sqlserver 2000 which in case is far more useful than vfp dbf's like for example table limitations up to 2gb only in VFp... i just want to document it for my students.. i got one now... thanks for the idea.thanks jezemine,actually im studying sqlserver 2005 right now too... the problem the school where i teach has sqlserver 2000 installed. unlucky for them coz the school cant afford the license.thanks guys! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-10 : 04:12:47
|
| "table limitations up to 2gb only in VFp"Also a DATABASE SIZE limitation in the freebie MSDE version (increased to 4GB in the SQL 2005 freebie).Google gives some useful hits.But in terms of "classroom work" the discussion is probably about ISAM v. Relational database.Then things like COMMIT/ROLLBACK, backup whilst database in use, query optimisation (index statistics), replication, data warehousing, the list is pretty endless!"unlucky for them coz the school cant afford the license."No dirt-cheap Educational version?The lightweight SQL Express is free, as are the Client Tools I think.Developer version (which is the same full-fat version as Enterprise, but not licences to run production applications) is about $40 I think ...Kristen |
|
|
|
|
|
|
article on advantages of sql server over VFP