Visual Fox Pro Upsizing Wizard

Asked By 0 points N/A Posted on -
qa-featured

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.

This is done by calling sp_dbcmptleve; stored procedure in SQL Server.

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.

SHARE
Answered By 0 points N/A #156522

Visual Fox Pro Upsizing Wizard

qa-featured
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.
 
SQL Server 2005
 
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

Login/Register to Answer

Related Questions