Export to SQL Server

[mobrien8]

I am a systems engineer and have never worked with FileMaker. Our Client is (for whatever reason - not important) wanting to migrate their "servers" from a mish-mosh mac/unlicensed ms server environment to a fully legal and licensed microsoft environment. Is there a way for a dummy like me to export the current FileMaker Server 7 data into SQL? And if so, will the client workstations still be able to connect? I have found something called FMPROMIGRATOR, but the website does not load...

as always, "any help would be appreciated"

[stanley]

Mobrien8:

Welcome to the Forums.

Exporting the data itself is fairly simple. You can export a table out in a number of formats, including CSV, SYLK, DBF, DIF, tab-delimted text, and so-on. That's all in File->Export Records...

However, all you get is the data. Not the calculations, scripts, formatting, and the like. Using something like FMPro Migrator would certainly help.

-Stanley

[Wim Decorte]

And if so, will the client workstations still be able to connect?

Not with FileMaker Pro on the workstations. At least not easily. FMP can access a SQL backend db but it has to import records to do so. And you'll have to export them back to the SQL db when done. That's a lot of work. If you're not going to keep the data in filemaker (FileMaker Server), then you're better off writing your own front-end in VB or something. Or use Access.