🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1579

Re: SQL vs. VDB or VDB Client / Server

#1579
From: Greg Hill
Date: Wed, 22 Oct 1997 00:00
47 lines
2340 bytes
Brian Evans wrote:
> 
> Greg Hill wrote:
> >
> > Yes, I agree now that I've done a little research and understand what a
> > database server is.  SQL is the database/file format that is setup with
> > the database server along with lots of other things as far as
> > configuration goes.  I also know now that I could use VDB as the front
> > end or VDB SQL or any language that includes SQL commands.
> >
> > Now I wonder how hard is it to set up the database server.
> > How hard will it be to convert my current code to use SQL or should I
> > say understand SQL command syntax.
> >
> > Yes 64mbs was not what I meant<g> 64k is correct.
> >
> > Thanks very much for your help.
> > Greg
> 
> Depending on which SQL server you chose there can be very
> little setup required or a lot. VdB Client/Server includes
> a utility to migrate dBase tables to an SQL database. The
> only thing you need to change in your programs is
> the USE lines to include more information (basically
> database.tablename instead of DBF filename) and make
> sure index tags are the proper case (it matters for most
> SQL servers - NAME and name are two different index tags)
> 
> dBase automatically converts you regular dBase commands
> into what the server requires. It should only take a
> day or two to get your program using tables from the
> server. More depnding on the server you choose.
> 
> I've found MS SQL Server easy to setup and configure.
> Oracle is a lot harder (you have to install Oracle
> networking - SQL*NET) and it's tools not well though
> out. But Oracle seems to look better on a resume :)
> 
> Brian

>>VdB Client/Server includes a utility to migrate dBase tables to an SQL database.

That is one feature they did not tell me about when I called Borland.
This is very good news.<g>:-)

Thanks again, Greg
Technical Details
Message-ID: <344EE7DD.6B4F@n2.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bcd473$2448a740$828471cf@greg> <343DD21C.819@sympatico.ca> <344E36A0.1FE7@n2.net> <344F221A.5FB2@sympatico.ca>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,f706ce8ff3602deb
X-Google-Attributes: gidff5a1,public
From: Greg Hill <ghill@n2.net>
Subject: Re: SQL vs. VDB or VDB Client / Server
Date: 1997/10/22
Message-ID: <344EE7DD.6B4F@n2.net>
X-Deja-AN: 282699600
References: <01bcd473$2448a740$828471cf@greg> <343DD21C.819@sympatico.ca> <344E36A0.1FE7@n2.net> <344F221A.5FB2@sympatico.ca>
Organization: Serv-U Computers
Newsgroups: borland.public.vdbase.data.sql