I'm looking to migrate a visual foxpro database to SQL server. Before I map and migrate over to the new system I need to get an understanding of the structure of the old one and cleans the data. Unfortunatley I don't have any of the orginal design documention. Is there a way I can import the visual foxpro data files into Enterprise manager? Or what method would you recommend to first get an understanding of how the database works?
You should start by profiling the data and building a metadata repository. I have some fox code to do this on my blog at blog.todmeansfox.com that will give you a head start in this effort (click the profiling link).