Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filemaker to Sqlserver
- Thread starter kalkumar
- Start date
1. Export the Filemaker data to a text file and import using SQL DTS/SSIS.
2. Use Filemaker's ODBC connectivity to write the data out. (I understand this is a very slow process.)
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
A virtual machine ate my accounting data. I transferred it to a physical box, then I beat it to smithereens with a sledgehammer. I feel better.
2. Use Filemaker's ODBC connectivity to write the data out. (I understand this is a very slow process.)
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
A virtual machine ate my accounting data. I transferred it to a physical box, then I beat it to smithereens with a sledgehammer. I feel better.
Hi - just to add to Phil's post - extracting data from Filemaker is pretty slow. I currently use SSIS to do a few data extracts from Filemaker (directly - I set up ODBC on the server and set up the appropriate Filemaker permissions) and the extraction is probably the slowest part of the process. I also found that some of the normal SQL constructs that I'm used to using aren't supported in Filemaker, so I grab everything I need from it, put it in a staging table, and then do my manipulation/selection from there.
HTH,
Doc Tree
- Status
Similar threads
- Locked
- Question