Article View: borland.public.vdbase.data.sql
Article #1579Re: SQL vs. VDB or VDB Client / Server
From: Greg Hill
Date: Wed, 22 Oct 1997 00:00
Date: Wed, 22 Oct 1997 00:00
47 lines
2340 bytes
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-mailReferences:
<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