Home > Database Convertion > Step for Migrating Data from Foxpro database to SQL Server, using SSIS

Step for Migrating Data from Foxpro database to SQL Server, using SSIS

For the migrating data from Foxpro database to SQL there is two solution as below

Requirement :

Before starting the steps, please make sure the Microsoft OLE DB Provider for Visual FoxPro and Visual FoxPro ODBC Driver is installed.

Solution1:

Use the Microsoft OLE DB Provider for Visual FoxPro to load data from Visual FoxPro database

  1. Create a new SQL Server Integration Services(SSIS) package.
  2. Add a Data Flow Task(DFT) to the package.
  3. Select the DFT, and go to Data Flow designer page.
  4. Add a OLE DB Source to the package.
  5. Double-click the OLE DB Source, click “New” > “New” to create a connection to Visual FoxPro.
  6. In the Connection Manager, please select “Microsoft OLE DB Provider for Visual FoxPro”
  7. Type the file path of a Visual FoxPro database(e.g. C:\Address.dbc).
  8. Test the connection by clicking button “Test Connection”
  9. Click “OK” > “OK” to apply.
  10. Now, we can select a table from the Visual FoxPro database in the OLE DB Source editor.

Solution2:

Use the Visual FoxPro ODBC Driver to load data from Visual FoxPro database

  1. As you done, create a DSN pointing to VFP free table using odbcad32 from SysWOW64 folder. I would suggest you using System DSN instead of User DSN.
  2. Create a new SQL Server Integration Services(SSIS) package.
  3. Add a Data Flow Task(DFT) to the package.
  4. Select the DFT, and go to Data Flow designer page.
  5. Add an ADO NET Souce to the package. Please note, ADO NET is started to support from SSIS 2008. In other words, in SSIS 2005, there is no ADO NET source.
  6. Double-click the OLE DB Source, click “New” > “New” to create a connection to Visual FoxPro.
  7. In the Connection Manager, please select “Odbc Data Provider”
  8. Select the DSN we created before, and then test the connection, make sure it is successful.
  9. Click “OK” > “OK” to apply.
  10. Now, we can select a table from the Visual FoxPro database in the ADO NET Source editor. If it is fail, please try using SQL Command mode.

The two drivers can be downloaded from:
http://www.microsoft.com/downloads/en/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en
http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: