Discussion Locked

ERwin and Visio

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are exploring using ERwin or Visio to reverse engineer our FoxPro tables as part of migrating the data to SQL Server 2000 (and normalizing the data in the process). Do either of these products support reverse engineering of .dbf tables?

5 replies

by steved

ERwin certainly does support reverse engineering from FoxPro. Then it will let you turn right around and create your entire schema directly on SQL Server. No fuss.

Steve Diamond

by peter ritchie

Visio will allow you to reverse engineer from and ODBC datasource (including DBF/FoxPro)

If you are already subscribing to MSDN you may be getting Visio already. ERWin will cost a few bucks.

Once reverse engineered the schema can then be "exported" or generated to SQL Sever 2000. If you're going to use Visio with SQL Server 2000 make sure you read MSKB article Q286026 (http://support.microsoft.com/support/kb/articles/Q286/0/26.ASP).

This discussion is closed to new replies.