Get a Jumpstart with our Sample Apps
Results 1 to 7 of 7

Thread: MS SQL Database design tool ?

  1. #1
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    58

    Default MS SQL Database design tool ?

    Hi Guys,

    I have started working with Alpha. I come from an environment where all the Tables are designed and created in a dictionary.
    I am looking for something similar to design my mainly MS SQL Database and Tables. So for a project I can design the database and all that goes with it and save it away to be backed up.
    It must be able to write the scripts to create the tables on the backend. Should I get to a different site I can just run the scripts and create the backend data.
    So has anyone have a suggestion to what tool if any is available to do this process.

    Many thanks

    Neville

  2. #2
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    5,830

    Default Re: MS SQL Database design tool ?

    You do have the option to use mssql, MySQL, dbf and others including mariadb and access.

    I personally use MySQL and sqlyog for webapps
    Some of the people here use mssql with Ms tools and others that will help you backup/download the databases.
    I can't remember the Chinese tool most on here use for mssql. Hopefully one of them will step in with the name for you.
    Dave Mason
    dave@aldaweb.com

    Skype is dave.mason46

  3. #3
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    58

    Default Re: MS SQL Database design tool ?

    Thanks Dave

  4. #4
    "Certified" Alphaholic glenschild's Avatar
    Real Name
    Glen Schild
    Join Date
    Apr 2000
    Location
    Frome, Somerset, UK
    Posts
    1,403

    Default Re: MS SQL Database design tool ?

    Hi Neville

    My "weapon of choice" is Navicat but I also use Dezign for Databases. Both cost! Both can manage your interaction with the backend database.

    Kind regards

    Glen
    Glen Schild



    My Blog


  5. #5
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    58

    Default Re: MS SQL Database design tool ?

    Thanks Glen,

    Will check it out.

    Neville

  6. #6
    Member
    Real Name
    Doron
    Join Date
    Dec 2011
    Location
    NJ, USA
    Posts
    165

    Post MS SQL Database design tool and Reverse Database Engineering

    Hi Neville ,

    Check this article which is: Reverse database engineering and database design and see the tool that I am using for the last 16 years and check the video as well. Its name is xCase and every thing that needs to be done such as: Creating scripts, creating tables, stored procedures, views and relations all in one product. It will generate the script to create or update the database. That data modelling tool works for all known databases.

    Regards,

    Doron

    The Farber Consulting Group, Inc.
    Main Web Site: http://www.dFarber.com
    No Interest Loans Application
    Last edited by DoronF; 01-23-2016 at 12:41 AM.

  7. #7
    Member
    Real Name
    Neville Dearham
    Join Date
    Jul 2015
    Location
    Cape Town South Africa
    Posts
    58

    Default Re: MS SQL Database design tool ?

    Many thanks Doron.

    Checked it out. Seems like this could be the one.

    Regards

Similar Threads

  1. A free U/I design tool
    By jkwrpc in forum General Questions
    Replies: 5
    Last Post: 12-03-2012, 04:06 PM
  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, 05:21 PM
  3. reporting tool for database structure
    By marcuswolfe in forum Archived Wishlist
    Replies: 10
    Last Post: 04-10-2009, 10:23 PM
  4. tool management Database
    By Luc Pilon in forum Alpha Five Version 7
    Replies: 2
    Last Post: 10-11-2006, 10:39 PM
  5. V7 Report Design Tool Menu
    By John Gamble in forum Archived Wishlist
    Replies: 5
    Last Post: 08-26-2005, 06:08 PM

Posting Permissions

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