Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Export to SQL Server

Featured Replies

  • 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"

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

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

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.