Post reply

Import VFP DBC into SQL 2000 server

  • October 27, 2004 at 3:27 pm

    #60640

    I need to import tables in VFP DBC into SQL 2000 server using DTS so then I can make any data conversion to some tables . After finish data conversion, I need to export them back to VFP.

    Does anyone know if that will affact the functionality of tables in the VFP DBC.

    Thanks for your help.

  • October 28, 2004 at 10:39 pm

    #528363

    I am not sure what motivates your strategy of moving into SQL and then back out, but I suspect the main problem would be in type conversions between Fox and SQL.  In order to minimize effects on the DBC, I think you would want to export the data back into Fox in a separate DBC than the original and then import the records from the new DBC back into the original. This would leave the structure of the old DBC intact. You might have to deal with some type conversion issues.

    I would also try to think about what you want to achieve and if there might not be a better strategy for it.

  • November 4, 2004 at 12:15 pm

    #528982

    Thanks, Smeeks,

    I decided to learn FoxPro and use that to do the conversion, so that I don't need to worry about the type conversion.

    Thanks again.

  • November 4, 2004 at 6:55 pm

    #529035

    Very wise.  I know many languages, but I think knowing Fox gives me a big advantage over those who don't.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply