How to automate FMP 8 and SQL Server synchronization???

[mshar]

Hi all,

We have both FMP and SQL Server in our company. Most of my company's data is on FMP. What we are trying to do is have an "Export to PDF" functionality available on the IWP version of our database. We have the database online but the Export script does not work in IWP (its greyed out in web-compatibility).

1) Is there any work-around for this functionality?

We are also thinking of having SQL Server as a middle tier between FMP and Web Interface (most probably built in .NET). I have made both FMP and SQL Server talking. I can send and receive data to and from FMP.

2) Is there a way we can automate this process of synchronization so that if we have new data in SQL Server, we can feed it to FMP simulatneously (vice-versa) or may be at regular intervals. I read about some plugins like FMROBOT. Is there any freeware?

Please help,

Thanks so much in advance,

MAX

[Wim Decorte]

If you already know how to push/pull data between FM and SQL then you could write a Windows service to sit in the middle and query FM or SQL on an interval and push new data into the other database...

[mshar]

that sounds interesting but i do not have that much time to venture into a whole new field...is there any application that we can probably buy that does the same thing...

do these-FMROBOT or FM-Migrator have some functionality like that???

Please help...my whole project depends on this...

[mshar]

Hi Wim...

I am also thinking of using the DTS service in SQL Server and control Import/Export from the SQL Server itself...

1) Is this approach possible and feasible?

2) Are there any step-by-step instructions for setting up the system for this.

3) Will this driver "SequeLink ODBC 5.4 Driver"

be enough...

Thanks again,

Max

Edited January 25, 2007 by Guest