Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: convert foxpro 3.0 table

    Hi,

    I've got about 6000 tables in foxpro 3.0 and a database in sql srv 2000.

    now i've to convert the data of these 6000 tables into the database. the problem is that i have to convert all the tables seperatly!

    is there a tool where i can convert these tables automatically?

    i know it can with DTS, but the 6000 tables are divided over 1400 directories. So with DTS i can't convert them automatically.

    does anyone know a solution?

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Wink Conversion

    I dont see why not. Setup a string of load thru a query that loops. Try a complete import. I'm sure it can be done. You might want to test the process and do the conversion during off hours when there no other system activity.

    Not a sermen

    Just a thought

  3. #3
    Join Date
    Sep 2003
    Posts
    2

    Thumbs up

    Quote Originally Posted by garrydawkins
    I dont see why not. Setup a string of load thru a query that loops. Try a complete import. I'm sure it can be done. You might want to test the process and do the conversion during off hours when there no other system activity.

    Not a sermen

    Just a thought
    so you are saying that i can loop through the directories with a DTS package?

  4. #4
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Arrow Conversion

    Yes, That's correct.
    It may take some time to put together so doing manually depend on whether this process will need to be run multiple times????

Posting Permissions

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