Visual Fox Pro Upsizing Wizard

Asked By Jeo Tolbert 0 points N/A Posted on - 02/07/2013

Hi People,

I need to move a database from Visual FoxPro (VFP for the diehards) to a SQL Server. While moving I got into unexpected problems.

The absences of a .dbc file which is necessary by the Visual FoxPro Upsizing Wizard.

The error: The Upsizing Wizard could not set the SQL Server database to proper compatibility level for upsizing. In order to upsize, Visual FoxPro must set the compatibility level of the target SQL database to 6.5.

The Upsizing Wizard could not set the SQL Server database to proper compatibility level for upsizing.

In order to upsize, Visual FoxPro must set the compatibility level of the target SQL database to 6.5

This is done by calling sp_dbcmptleve; stored procedure in SQL Server. Only the DBO, members of the sysadmin fixed server role, and the db_owner fixed database role (if the database whose compatibility level is to be changed is the current database) can execute this procedure.

Please ensure the SQL login you are using has the appropriate rights to perform this action.

• Status: Open
• Question Views: 1257
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Others

Answered By Laz Zebbena 0 points N/A #156522

Visual Fox Pro Upsizing Wizard

Hi,

 

This 6.5 compatibility error occurs if you are running SQL server 2008 or above. It works fine on SQL Server 2005 so you can download it and it is compatible with 6.5.

 

 

And if .dbc file is missing create it. Following is the step to create it:- 

 

1. Open Visual Fox Pro then click on file > New > select Database > click on New file.

 

2. Then save the file. This file is saved with .dbc extension.

 

3. Click on the add table button. 

 

4. When the open file option appears, go to the directory where all .dbf files are available and from there select the files you want to import into SQL database.

 

Regards,

Laz Zebbena

About Laz Zebbena

Questions
2

Answers
101

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 02/19/2013
• Question Category: Microsoft Others