Alpha Video Training
Results 1 to 5 of 5

Thread: Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

  1. #1
    Member
    Real Name
    Doron
    Join Date
    Dec 2011
    Location
    NJ, USA
    Posts
    173

    Post Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

    Hi Guys,

    I still see many developers that neglect their database design. The below article can help some developers to be more productive and design an optimized database. Obviously, some tools really help you to get there. Optimized database means best performance. Check this article I did lately: Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?. It mentioned some free tools and some in expensive ones.

    Regards,

    Doron
    The Farber Consulting Group, Inc.

    Main Web Site: http://www.dFarber.com
    Avis Car Rental Software

  2. #2
    "Certified" Alphaholic
    Real Name
    John Koh
    Join Date
    Jan 2004
    Location
    Maryland, USA
    Posts
    1,062

    Default Re: Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

    Hi Doron,

    Does XCase support the A5.dbf or it has to be one of sql?

  3. #3
    Member
    Real Name
    Doron
    Join Date
    Dec 2011
    Location
    NJ, USA
    Posts
    173

    Post Re: Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

    Hi johnkoh,

    It supports Visual FoxPro DBFs as far as I know. The beauty is the whole info about the model is stored in DBFs. So if you have Visual FoxPro you can make some changes of the attributes directly. I worked more then 20 years with Visual FoxPro so for me it is simple as to work with Alpha AnyWhere. But A5.dbf I never tested it since I worked with ms sql as the back end. You can contact xCase directly and ask them.

    Regards,

    Doron
    The Farber Consulting Group, Inc.

    Main Web Site: http://www.dFarber.com
    Alpha anywhere software development
    Last edited by DoronF; 04-09-2019 at 04:19 PM.

  4. #4
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Re: Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

    Valid point Doron.
    I use Visual Paradigm but the community edition
    https://www.visual-paradigm.com
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  5. #5
    "Certified" Alphaholic kkfin's Avatar
    Real Name
    Kenneth
    Join Date
    Dec 2006
    Location
    EU
    Posts
    1,515

    Default Re: Why do we use data modeling tool for database design for MS SQL or MySQL or MS Access databases?

    XCode seems to be an interesting solution. It is clearly concentrated to databases which actually is not a bad thing at all.It is an advantage when you learn the software. An other option is Spark systems Enterprise Architect (little similar like Teds tool) and the price (corporate version) is little lower that Xcode have. You can also integrate EA to CodeTrigger if you are also a MS-VS-Platform developer.

    Ken

Similar Threads

  1. MS SQL Database design tool ?
    By Neville in forum Database Design
    Replies: 6
    Last Post: 01-23-2016, 09:55 AM
  2. Why Is there no Database Design Flow Charting Tool
    By gigels0070 in forum Alpha Five Version 10 - Desktop Applications
    Replies: 7
    Last Post: 12-21-2010, 04:21 PM
  3. Anybody Use Database Modeling Software?
    By Victor Hernandez in forum Alpha Five Version 5
    Replies: 0
    Last Post: 12-07-2004, 08:48 AM
  4. Anybody use Database Modeling Software?
    By Victor Hernandez in forum Alpha Five Version 6
    Replies: 0
    Last Post: 12-07-2004, 08:29 AM

Bookmarks

Posting Permissions

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