SQL Server Performance

importing a visual fox pro file -dbf contians herb

Discussion in 'General DBA Questions' started by pelegk1, Dec 5, 2005.

  1. pelegk1 New Member

    importing a visual fox pro file -dbf contians herbew
    how can i do this?at the moment i recive an error message :
    http://bb.1asphost.com/pelegk2/error-dbf.GIF
    and when i open the file in fo pro i see only strange characters and not hebrew - why?
    thnaks i nadvance
    peleg
  2. satya Moderator

    Check the schema difference between foxpro DBF & SQL database and use proper datatypes for the column data.

    BTW are you using DTS to transfer the data?

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. daspeac New Member

    Hi peleg, I believe that this problem can be fixed by Recovery Toolbox for SQL Server application. Users often ask, can Microsoft repair mssql 2005 database? It is not always possible with in-built database recovery solutions, therefore we can try 3rd party applications

Share This Page