Path: news.easynews.com!easynews!sjcppf01!e420r-sjo4.usenetserver.com!usenetserver.com!newshub2.rdc1.sfba.home.com!news.home.com!news2.nash1.tn.home.com.POSTED!not-for-mail From: "Clay Davidson" Newsgroups: comp.databases,comp.databases.ms-sqlserver,comp.databases.theory,microsoft.public.sqlserver.server References: <3bffa6cb.8398576@news.tcd.ie> <3c010367.15054479@news1.eircom.net> <3c028322.17510658@news.tcd.ie> Subject: Re: Throughput and storage requirements questions for modern vs old database processing apps Lines: 41 X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Message-ID: Date: Tue, 27 Nov 2001 06:25:36 GMT NNTP-Posting-Host: 67.163.21.203 X-Complaints-To: abuse@home.net X-Trace: news2.nash1.tn.home.com 1006842336 67.163.21.203 (Mon, 26 Nov 2001 22:25:36 PST) NNTP-Posting-Date: Mon, 26 Nov 2001 22:25:36 PST Organization: Excite@Home - The Leader in Broadband http://home.com/faster Xref: easynews comp.databases:90768 comp.databases.ms-sqlserver:61985 comp.databases.theory:19123 microsoft.public.sqlserver.server:147200 X-Received-Date: Tue, 27 Nov 2001 02:40:48 MST (news.easynews.com) I only read thru some of the posts so this may not even be appropriate anymore but ...... 90 mb is a very big database for clipper in 1992 or so but with the screaming machines we have now and the faster networks, it may be ok. Keep in mind that the entire data file has to be brought across the network when it is used. The .ntx files are clippers index files. The .dbf files are the database files. These are in DBASE III+ format which was the standard database format at the time. Foxpro and dBASE should be able to open and read the files. They may even be able to use the indexes. At least the earlier versions might. I have not used either of these programs in years. The indexes and the database files may be fragmented very badly. If you can open and compact them with foxpro or if you can get an old clipper programmer that still has his hand in to help. Oracle is pretty much the standard in client server rdbms software. SQLServer is ok and is much easier for a novice to become useful with. Centura Softwares SQLBase is probably the easiest of them all to learn and some of its syntax will carry forward with oracle. hope this helps, clay "John Becich" wrote in message news:GDEM7.8134$WC1.962592@newsread2.prod.itd.earthlink.net... > Paul, > Thanks again. I'll be in touch. > John > > > > > >