Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Data Migration!!!!

Author  Topic 

ruchirj07
Starting Member

37 Posts

Posted - 2008-01-29 : 01:57:20
Hi,

Is there any way to migrate data from Sql Server to FileMaker Pro?
I have an approach of using Excel File as intermediate step for the migration. Is there any better approach?

I'll really appreciate as this is urgently required.

Rgds,
Ruchir

dineshasanka
Yak Posting Veteran

72 Posts

Posted - 2008-01-29 : 06:01:32
There ar no direct ways of doing it. you may have to try it with csv file or text file
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-01-30 : 02:17:39
Depending on your file maker Pro version , it may be possible to connect from FileMakerPro and Import data from SQL Server

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-01-30 : 02:59:48
newer versions of filemaker support connecting to SQL Server.

http://www.filemaker.com/help/15a-Data%20sources2.html


you might also be able to use the filemaker odbc drivers in conjunction with SSIS or DTS to load the data into filemaker. I think the remote access to filemaker data is only available on the advanced server version of the product though.


-ec

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-01-30 : 03:04:12
Linked server?

http://www.connectionstrings.com/?carrier=filemaker


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -