Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Join Date
    Apr 2004
    Location
    India
    Posts
    3

    Post Unanswered: Advantages of SQL Server

    hi ! my boss is thinking of redoing our accounting system which is currently running on FOXPRO - we are planning on a VB/SQL SERVER platform.but he isn't convinced that the benefits of SQL server outweigh those offered by FOXPRO especially since everyone in the office is very comfortable with Foxpro.Can anyone give me some solid advantages of SQL SErver or any other RDBMS over Foxpro ?

  2. #2
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    FoxPro?

    Accounting?

    Security?

    I got it...how 'bout an abacus, quill and parchment....

    Ok...enough with the sillyness...guess they keep advancing it...why? I have no idea..

    http://gotdotnet.com/team/vfp/

    What version of foxpro?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    A couple of observations...

    VFP and MS-SQL are not mutually exclusive. You can have the benefits of both if you choose. SQL Server can provide the "back end" at the server, and VFP can provide the "front end" at the client.

    SQL Server allows much better security, eliminates damaged files due to workstation disconnects, better performance, practically infinite ability to scale.

    -PatP

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I still have a Programmer's Manual for FoxPro 2.0, right before it was bought up by M$. It presented a serious competition to Borland's dBase IV, and gave me an opportunity to really dive into SQL....Anybody wants to buy 19 Installation disks (1.44MB) for FoxPro 2.6 with a Connectivity Kit?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Still got your Access 1.2 disks?



    First consultant gig was on 2.0



    Now where did all the side business go?

    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    I've still got a set of 5 1/4 Paradox discs (pre-Windows). 8

  8. #8
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Hey, Paradox 4.0/4.5 was my next step (actually a step backwards in regards to SQL) I believe I still have them too, not sure about the version...Anyone?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  9. #9
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    ...And I also have the first decent VB for DOS, 2.0. Fits on 2 1.44MB floppies, very compact and suitable for travel. Very low minimum system requirements, produces beautiful forms and popup dialog boxes
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  10. #10
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    Sorry, my old Kaypro doesn't have 3 1/2 inch drives. Just the old 360KB floppies. No HD either.

  11. #11
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I still have a pair of 8" floppies with Vulcan on them.

    -PatP

  12. #12
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    I knew I should have kept my first program! But carting all those punch cards around got to be a real pain (literally!)

  13. #13
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040

    Smile

    I tossed my paper tape after the program went into production!

  14. #14
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    okay..

    i used to get up each morning 3 hrs before i went to sleep and clean the road with my tongue, for 3 cents a week. considering the shoebox at the bottom of the lake that we lived in had a rent of 32 cents a week, we had to do a lot of odd jobs.

    my first for pay consulting job was at mr slate's quarry.
    i used to maintain(feed) the first database ever created called "joe" after it's creator "joe". it used a series of stones tied to sticks attached to a pelican. and through a series of levers we could calculate pi to 1 place in 7.3 hours.
    being a very exclusive database, there was only one copy and since it was a bit on the gamey side, it couldnt be kept indoors.

    i have a copy in a storage container in my back yard, it's not totally oledb compatible but with a bit of work it could be dblibrary.

  15. #15
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Wow! You still have a copy of the "Joe" database? What a coincidence! At the back of one of my file cabinets I still have the original RFP I submitted for the project.

    Did you know it was actually a conversion from an older legacy system?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •