Filemaker Pro to SQL Server 2000

[anthonymel]

This is not an official "how to" but just thought I put it out there and see what out guys thought.

I needed to export a Filemaker Pro 7.0 database into SQL 2000.

After a few unsuccessful tries with the filemaker drivers using the Data Transformation Services and finding little or no help on the net on how to do this, I realized that converting filemaker pro db into Microsoft Access worked much better.

So from within Filemaker Pro export as a .csv (comma separated values) Then create a new db with Access. Click file >> get external data >> import

Click on your .csv file. Follow the wizard and make sure to select to create a new table, no linked text. Rename the attribute fields to match your filemaker db. After this wizard is done you should have your table neat and with all your info from filemaker.

The next step would be to use the data transformation services in SQL Enterprise manager to convert a access database into SQL Server 2000.

That’s about it.

Feel free to comment

 

[mrdenny]

It would have been easier to load the csv file directly into SQL Server using DTS, BCP, or Bulk Insert.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[anthonymel]

Probably right on that one. I'll try it that way tomorrow.

Anthony