Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    4

    XCase, Visio, SQL Server Mgmt Studio...?

    I'm looking for advice as to the best approach for redesigning our data infrastructure & bringing it into SQL Server. This would include data modeling, redesign of existing .dbf tables, analysis of relationships, inclusion of not-yet-existing tables into the whole mix, generation of DDL scripts, etc. Tools like ERWin, etc., at out of the picture due to cost. XCase or Visio Enterprise Architect might be possibilities. Given those two tools (or ones of similar price level and capabilities), or just using the SQL Server Mgmt Studio to design "test" databases first - what do you recommend & why?

    Thanks much, Randy

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    how many tables? if the answer is under a hundred, use paper and pencil, then write the DDL directly in a text editor (it's easy once you understand which sequence to declare the tables in)

    or mock it up in access (which has a great front end), and upsize
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2007
    Posts
    4
    There are currently probably 200-300 or more tables, and more will be added.

Posting Permissions

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