Backup data From Filemaker Pro 11 to SQL Server

[TiagoCosta17]

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.

[menno]

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.

[TiagoCosta17]

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.

[menno]

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?

[SuperWimmie]

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.