February 6, 200619 yr Newbies 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"
February 6, 200619 yr 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
February 7, 200619 yr 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.
Create an account or sign in to comment