Another good option (if you are not concerned with VFP) is the Sybase stuff - Data Architect or AppModeler. DataArchitect is probably the better choice because it deals with conceptual data models instead of physical, and you won't use any of the "App" stuff in AppModeler unless you are using VB or PowerBuilder.
>For VFP I would recommend xCase. As far as I know it's the only one that will reverse engineer a VFP database. The Pro version also supports SQL Server and, I think, Oracle. I'm pretty sure it doesn't support DB2 but they may have added that. If you don't need VFP support or if that's not your number one priority then ErWin is probably your best choice.
>
>>Hello All,
>>
>>I am going to be getting a new CASE tool soon and thought I would seek opinions as to which one is best for use with VFP (local data) and SQL Server 6.5 and up. Ideally, it would also support other back-ends such as Oracle and DB2.
>>
>>I've looked (briefly) at XCase and used ErWin before a little - thoughts on these or others? Recommendations?
Eric Shaneson
Cutting Edge Consulting