Jump to content
  • 0

Backup data From Filemaker Pro 11 to SQL Server


TiagoCosta17

Question

Posted

Hello Everyone,

 

Small question, does anyone ever made a nightly backup of data , from a Filemaker file in one server to an MS SQL Server DB in another using a PULL method ? ( meaning that the SQL server DB will pull the data automatically )

 

I've installed the Windows ODBC driver (provided by filemaker in the CD) and created a new DSN, my problem is I cannot make a connection between the SQL SERVER MANAGEMENT STUDIO and the FILEMAKER FILE using the DSN that I created.

 

Another aspect is that the SQL SERVER is on a 64-bit machine (if that makes any diference)

 

Thanks a lot in advance

 

Tiago.

4 answers to this question

Recommended Posts

  • 0
Posted

Filemaker should be running and you need a user that can access the filemaker-file via odbc (through the Filemaker-Application), also a normal filemaker-client can only make files odbc-accessible to the localhost and not to the network.

 

If you want to access a filemaker-file through odbc from the network you'll need to use Filemaker Server Advanced since the standard-version does not support being an ODBC-source.

  • 0
Posted

Actually we found out that it is not possible using Filemaker Server 11 :/

 

We change to a Filemaker Server 12 in a 64 bit machine , using the 64 bit driver , and the SQL server is also running in a 64 bit machine.

 

Worked, we could select the data in the SQL server and pull it to our new tables.

  • 0
Posted

Strange that the configuration MsSQL-Win64 with a 32-bit DSN (to FMS11) does not work. I can't test that configuration here, so I can't say why that is. However I do get the 32-bit DSN working just fine on a 64-bit machine in excel and openoffice, so I'd expect it to work with something like MS-SQL as well. Are you sure you configured it correctly?

  • 0
Posted

You have to use the ODBC driver which is the same bits as the application.

 

MySQL database 64 bits? Use the 64 bits ODBC driver.

 

FM 11 is 32 bits, so use the 32 bits driver.

 

FM12 server is 64 bits.

 

Both ODBC drivers will connect with each other, no matter the bits they are using.

 

This is as far as I know.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...