Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007

    Unanswered: Foxpro Migration


    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?

    Thanks for any help you can give me.


  2. #2
    Join Date
    Jun 2004
    Long Island
    Dts (2000)/ssis(2005)

  3. #3
    Join Date
    Jul 2007
    You should start by profiling the data and building a metadata repository. I have some fox code to do this on my blog at that will give you a head start in this effort (click the profiling link).

    To get the exact schema into SQL server, use the FoxPro Upsizing Wizard, which will automatically create the DDL for you. Check for more info.

    Also, using SSIS is an option and works well as a pipe to move data into SQL Server.

Posting Permissions

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