Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Importing Visual Fox Pro Database Sql Server 2012

Answered Importing Visual Fox Pro Database Sql Server 2012

  • Tuesday, February 26, 2013 1:21 AM
     
     
    Sign In to Vote
    0
    I have a job that uses the visual fox pro oledb data provider to connect into a visual fox pro database and import data into sql server. It runs fine in sql 2008. I have a new server with SQL Server 2012. I installed the VFP provider on it as well. I went back in through the import wizard (how I set up the job on the original server) and tried to create it. I see the VFP provider in the drop down under data source. However when I go to click properties it just freezes in the import wizard and I have to kill it through task manager. Any idea why this would be happening?

    - Michael

    • Changed Type ArthurZMVP, Moderator Tuesday, February 26, 2013 2:20 AM revised to reflect the thread intent
    •  
     

All Replies

  • Tuesday, February 26, 2013 2:30 AM
    Moderator
     
     
    Sign In to Vote
    0

    I suspect the SQL Server Native Client 11 you use in the Data Export Import Wizard is not willing to support this VFP.

    I think you may need to use a lower version of SQL Native Client to extract the data into an intermediate media (think file).

    Arthur My Blog

     
  • Tuesday, February 26, 2013 7:56 PM
     
     
    Sign In to Vote
    0
    How would I got about doing that? Does that mean I'd have to uninstall the version of sql server I'm currently running?

    - Michael

     
  • Wednesday, February 27, 2013 2:40 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    You can have both SQL Server 2012 and SQL Server 2008 running side by side

    Arthur My Blog