DBF to SQL Server Troubleshooting

While working with DBF to SQL Server converter you may encounter unexpected behavior or result. Use the following information to solve some common problems and get the result you want. This summary is organized as a list of problem-resolution pairs. Each problem description starts with "P:" and each resolution - with "R:".

P: Error message "The specified table already exists"
R: When you specify MS SQL user from 'administrator' group (but not 'dbo'), MS SQL opens each table as [dbo].[table name]. By default, DBF to SQL Server converter opens all tables as [<user name>].[<table name>]. To resolve the problem select 'Connect as database owner' checkbox on 'Connect to MS SQL server' wizard page. Please note that the specified user must have enough privileges to write into the destination MS SQL database. Otherwise, the option will not take effect.

P: Indexes are missing in the resulting MSSQL database.
R: Current version of DBF to SQL Server converter does not convert indexes.

P: National symbols like á, â, ã, ç, é, î, ï, ô, ò, õ, ú, ù and others are not converted properly.
R: DBF to SQL Server converter uses the code page given in header of DBF file to interpret text fields of the tables. However, sometimes DBF file stores incorrect value of code page. For such situations DBF to SQL Server converter allows users to specify code page that will be used to interpret text fields instead of the built-in one. You can do this via "Use Encoding" combo box on "Step 2 of 4" wizard page.

P: Some table names and/or field names in the resulting MS SQL database differ from the original.
R: DBF and MS SQL accept different sets of characters for table names and field names. When DBF to SQL Server converter processes a name containing prohibited characters it replaces them with '_' in the destination database.

P: I see the error message "$filename$: Memo field not found"
R: In FoxPro/DBase format data of memo fields is stores in separate file. It is expected that the corresponding memo file is in the same folder as .dbf file and has the same name with one of the following extensions: .dbt, .fpt, .smt. Make sure there is the appropriate memo file in the same folder where .dbf file is located. Copy it from another folder if necessary.

P: I cannot uninstall DBF to SQL Server converter.
R: If you need to remove DBF to SQL Server converter from your computer, you can use "Add or Remove Programs" option in the Windows Control Panel.

If you came across some other kind of problem while using DBF to SQL Server converter, please contact our support service.