Export from FileMaker

[mahima]

hi,

I have tables in FileMaker, How to Export those table into Sqlserver database?

 

Thanks in advance

[AHunter3]

To literally Export, you isolate the records you wish to transfer and you export them to a file format that can be easily imported into SQL. That's probably not what you meant.

 

In FileMaker 9, you can define a data source within FileMaker as being a specified table in SQL. Once having done so, you can create a layout in FileMaker that utilizes rows & columns of the SQL table as its native data table, and then create a script to move data from any of the native FileMaker tables to the SQL table(s). This eliminates any need for the SQL system environment to play an active role (i.e., it doesn't have to IMPORT).

 

Also in FileMaker 9 as well as present in older versions, you can instead use native SQL commands to move FileMaker data into the SQL table, via ODBC (or JDBC). FileMaker does speak SQL but only as a second language; some folks have complained about the speed or dropped connections. The FileMaker 9 capacity to directly reference SQL data and treat it the same as FileMaker data (for the most part at any rate) would be far easier & more user-friendly for us FileMaker geeks at any rate, and based on my limited experience with ODBC, less frustrating all around.

[mahima]

To literally Export, you isolate the records you wish to transfer and you export them to a file format that can be easily imported into SQL. That's probably not what you meant.

 

In FileMaker 9, you can define a data source within FileMaker as being a specified table in SQL. Once having done so, you can create a layout in FileMaker that utilizes rows & columns of the SQL table as its native data table, and then create a script to move data from any of the native FileMaker tables to the SQL table(s). This eliminates any need for the SQL system environment to play an active role (i.e., it doesn't have to IMPORT).

 

Also in FileMaker 9 as well as present in older versions, you can instead use native SQL commands to move FileMaker data into the SQL table, via ODBC (or JDBC). FileMaker does speak SQL but only as a second language; some folks have complained about the speed or dropped connections. The FileMaker 9 capacity to directly reference SQL data and treat it the same as FileMaker data (for the most part at any rate) would be far easier & more user-friendly for us FileMaker geeks at any rate, and based on my limited experience with ODBC, less frustrating all around.

 

That means using ODBC we can directly export filemaker data to sQLserver database, this will create the tables in Sqlserver or copu only the data into already existing tables.

 

I heard that we can export Filemaker data into CSV file. And then use SSIS(Sqlserver Integration Services) to import tha data into Sqlserver?

 

Which method is best?

 

Thank you very much for your answer.

[AHunter3]

I don't know your system, nor do I know what routines & methods you would find most comfortable. If it were me, the 2nd option (defining the SQL datasource within Manage Data Sources, then script the setting of new-record values in SQL using native Filemaker scripting) would be the way to go, because writing Filemaker scripts is what I do, whereas mucking with SQL syntax is like trying to sing opera in unaccented Swahili. For you it could well be the opposite.

 

That means using ODBC we can directly export filemaker data to sQLserver database, this will create the tables in Sqlserver or copu only the data into already existing tables.

 

I have never tried using an ODBC command from within FileMaker to tell a SQL system to create an entirely new table. Can you? Dunno. Must you? Absolutely not, you can tell SQL to receive info constituting a new record.

 

A simple export to CSV or tab-delimited text followed by import of same data by your SQL system is pretty bulletproof but it requires two verbs (the FileMaker system must export, the the SQL system must import).

[mahima]

Hi,

Can you please help me which way I ned to follow to export data to Sqlserver?

 

1) First I will create the tables in Sqlserver.

2) Export file maker data to Tab/CSV files.

3) use those CSV/Tab files to import data to Sqlserver?

 

Can you please correct me whether my steps are coorect?

Or any measures to take care of?

I am new to this Filemaker.

Thanks.

[AHunter3]

That's essentially it. In FileMaker, to export, what gets exported is generally the FOUND SET of data, so if you don't want every record in a given table you do a Find first to isolate the data you do want to export. Other than that, yeah, what you typed = the steps you'd take.

[mahima]

Thank you ver much.

[mahima]

Hi,

I have one more question, is there any script to do the above steps? or I have to do it manually?

 

Thanks in advance

[AHunter3]

You have to create the script. It's a one-step script.

 

Export Records [restore export order , no dialog]