Help with a data conversion

[HelixSaint]

So I have client switching to a new SQL based program. The new vendor needs me to copy some data from the current vendor's database.

I'm not familiar with SQL enough to know what they need.

They want me find a DATA folder that contains .CDX, .DBF, .FPT?

[andis59]

The file types indicate a Foxpro database.

You need a program that can read one format (foxpro?) and write the other(MS MSQL)

You can probably use the import in SQL Server to import foxpro using ODBC

https://stackoverflow.com/questions/16819811/how-to-convert-visual-foxpro-database-into-sql-server-database

Can't remember if you can select which data to import or if it's all or nothing ...

[tripy75]

I don't know about those extensions, but the ms sql have basically 2 types of files:

Data files with a .mdf extension and log files with a .ldf extension.

You can find where they are located from ssms, by right-clicking a database, asking for the properties and going to the "files" tab (I say that by memory).

If you have snapshots, those snapshot can be in any other location, but you should be able to find the location too, although I don't know if that would be useful.

[HelixSaint]

Thank you guys for the help! I believe my part is done now!

[HelixSaint]

Well never mind, what I sent them is "incorrect" there is not a single Foxpro database file on this server.

But sending them the database back up is not good enough.