I have designed and tested a VFP 6.0 application prototype using local views. Just for my own learning experience I wanted to upsize the project to SQL Server. My system's administrator imported the VFP database to the server using SQL Server 7.0. We created a connection to the database and tested the connection. I tried to run the Upsizing Wizard and got to Step 5 - Select Target Database. Since the database was already there the Wizard identified it and "Existing" was checked. When I click Next, a message box pops up which reads, "The Upsizing Wizard could not set the SQL Server 7.0 database to proper compatibility level for upsizing.” The only option I am given is to click on Ok.
Any ideas and suggestions would be greatly appreciated.
Thanks,
Mike Coop
MIU - Data Analyst III
Kemper a Unitrin Business
(904) 245-5949
mcoop@eKemper.com