FoxPro 9.0 to Azure Storage via Azure Data Factory

Question

FoxPro 9.0 to Azure Storage via Azure Data Factory

Nalini Bhavaraju 100

Hi Team,

We are using FoxPro 9.0 x3 server in our organization that has some logs with emaint data. I am unable to find the database details.

I would like to know if there is any way I can download or import the data to SQL server in Azure or Azure Data lake using the ADF.

Fyi, I have server details and not database information.

Is there any supportive Microsoft documentation that I can refer to or can you please help me understanding if there a way I can achieve this connection and copy or download the data as we would like to decommission the legacy server.

Thank you,

Nalini Bhavaraju.

Venkat Reddy Navari 3,625 Reputation points Microsoft External Staff Moderator

2025-03-31T09:10:04.2166667+00:00

@Nalini Bhavaraju We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Venkat Reddy Navari 3,625 Reputation points Microsoft External Staff Moderator

2025-03-31T09:10:04.2166667+00:00

@Nalini Bhavaraju We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

@Nalini Bhavaraju
Migrating data from a FoxPro 9.0 server to Azure can be challenging, especially without specific details about the database. However, if you have access to the server, there are several options to simplify the process.

Here a simple and effective approach to achieve this using Azure Data Factory (ADF):

Find the Data: Log into the server and look for .DBF files—these are what FoxPro uses to store data (like your eMaint logs). They’re probably in a folder the app uses.
Extract the Data: If you can run FoxPro, export those files to CSV using this simple command:
```
   COPY TO "C:\ExportedData.csv" TYPE CSV
```
If you don’t have access to FoxPro: Use a tool like DBF Viewer to save them as CSV. Or install the Visual FoxPro ODBC driver to pull the data into a temporary SQL Server.
Move Data to Azure: Once the data is extracted, the next step is to move it to Azure: Upload the CSV files to Azure Blob Storage for easy access. In Azure Data Factory (ADF), set up a data pipeline: Source → Select the CSVs from Blob Storage. Destination → Choose either Azure SQL Server or Azure Data Lake, depending on your needs. If you have temporarily stored the data in SQL Server, ADF can seamlessly transfer it to Azure. In this case, you may need to set up a Self-Hosted Integration Runtime to connect your on-premises server with Azure securely.
Validate & Decommission: Once the data is validated in Azure SQL Server or Azure Data Lake, you can safely decommission the FoxPro server.

For more details, you can refer to the official Microsoft documentation:

ADF to Azure SQL

ADF to Data Lake

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Venkat Reddy Navari 3,625 Reputation points Microsoft External Staff Moderator

2025-04-01T15:50:19.23+00:00

Hi @Nalini Bhavaraju Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

FoxPro 9.0 to Azure Storage via Azure Data Factory

1 answer

Your answer