At 09:58 AM 01/31/2002 -0500, you wrote:
>If all you want is to do a visual design and get basic printouts and
>reports, Visio works wonderfully and is much less expensive than the other
>tools.  If you want something a bit more powerful, then I recommend you
>evaluate Embarcadero's ER/Studio.

  Brilliant, thanks for that link.  I was researching these a while ago and 
only found ER/Studio (Which was ~$4000).  After using it for a month, I 
decided that I could not warrant the cost for a piece of software that I 
would use only a couple of times a year.
  They offered to sell me a $2000 version that only worked on SQL Server.

  What I really would love (to my knowledge still doesn't exist) was a 
program that would allow for this type of situation:

I have a table:
   users (UserID, userinfo, address, state)

And I want to create it into two tables, without losing any referential 
integrity:

   users(UserID, userinfo, address, stateID)
   state(StateID, state)


  Embarcadero said they were developing a product to do that (but it was 
not in beta yet).  They said it would be a lot more expensive than the 
ER/Studio because it delt with the data, not just the table structure.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Fax / Phone: 860-223-7946
--
Need a Web Developer?  Contact me!
My Book: Instant ColdFusion 5  | http://www.instantcoldfusion.com
My New Book: ColdFusion: A Beginner's Guide February 2002
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to