Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Benny Thomas
  Where is Benny Thomas?
 Jeddah
 Saudi Arabia
 Benny Thomas
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Converting from DBF to Client Server
Thread ID: 143505 Message ID: 143605 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Projects and Design
Date: Thursday, August 30, 2007 9:16:28 AM         
   


> > Hi Ken,
> >
> > Very elaborate reply. My ratings to you. Although I have now idea of how MS SQL or MySQL looks like, I have an intention to lay my hands on the same to experiment. Is it similar to VFP tables (associated with some application) and if so what is that appliation? Or simply put, how can I get SQL?
> >
> > Benny
> >
>
> Benny,
>
> You will find SQL/MySQL looks quite a bit different from VFP, but if you look closely, you will see quite a fiew similarities. This is a screenshot of the SQL Server 2005 Server Management Studio:
>
>
>
> At first glance it looks quite a bit different, but look in the top right hand window. This is very similar to the table designer. Note the bottom right hand window. This is similar to what you get when setting field properties, etc. Note the Identity Specification properties - this is quite similar to the way you set up a VFP autoinc field. If you have a sound understanding of the principles behind creating databases in VFP, those same principles will serve you well when working with SQL. As to getting SQL, you must purchase SQL Server 2005, but I believe that MySQL is a free download. Tushar uses something else (can't quite remember the name of it - an age thing :( - perhaps he will chime in here) but I believe that what he uses is also free.
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)

Thanks Ken. I think for a start I will download the free MySQL to learn. I cannot ask my company to invest unless I am sure to give them immediate return on their investment.

Benny

ENTIRE THREAD

Converting from DBF to Client Server Posted by Allan Cerrudo @ 8/29/2007 12:54:51 PM
RE: Converting from DBF to Client Server Posted by Ken Murphy @ 8/29/2007 3:08:02 PM
RE: Converting from DBF to Client Server Posted by Benny Thomas @ 8/29/2007 3:53:56 PM
RE: Converting from DBF to Client Server Posted by Ken Murphy @ 8/29/2007 4:06:40 PM
RE: Converting from DBF to Client Server Posted by Benny Thomas @ 8/30/2007 9:16:28 AM
RE: Converting from DBF to Client Server Posted by Allan Cerrudo @ 8/31/2007 6:26:36 AM
RE: Converting from DBF to Client Server Posted by Ken Murphy @ 8/31/2007 2:52:57 PM
RE: Converting from DBF to Client Server Posted by tushar @ 8/29/2007 3:25:07 PM
RE: Converting from DBF to Client Server Posted by Allan Cerrudo @ 8/31/2007 6:23:38 AM