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.

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.

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

Answer Accepted: No
Question Category: Microsoft Others

Answered By Laz Zebbena 0 points N/A #156522