.com Solutions Inc. - logo  
Products - Header Buttons
.
FmPro Script Diff bullet item 7b FmPro Layout Diff bullet item 7b FmPro Migrator bullet item 7b CGIScripter
.
.
.

.
.

FmPro Migrator - Graphical Interface - Title Graphic

The FmPro Migrator FileMaker folder tab contains fields for entering FileMaker specific information for the migration process.

.

FmPro Migrator - FileMaker Tab
MacOS X
Windows
FmPro Migrator FileMaker Folder tab - 100K FmPro Migrator FileMaker Folder tab - Windows  - 29K


.

Button: Step 1 - Get Info
FmPro Migrator on MacOS X either directly reads the structure of an empty FileMaker binary file (FileMaker 2,3,4,5,6) or uses Apple Events via AppleScript to query the FileMaker Pro application for information about each of the database files which are currently open. Alternately, with FileMaker Advanced 8+ databases, FmPro Migrator reads the table creation XML code directly from the FileMaker clipboard. An ODBC connection to SQL Server is used to gather metadata for SQL Server to FileMaker migrations.
On Windows, FmPro Migrator reads metadata directly from an empty FileMaker binary file (FileMaker 2,3,4,5,6), directly from the clipboard, or from an ODBC connection to the FileMaker or SQL Server database.

Step 1 - AppleScript Icon Step 1 - Drag and Drop Icon Step 1 - Clipboard XML Icon Step 1 - ODBC Icon
FmPro Migrator MetaData Gathering Icons

Field: Output Directory - Browse button
This field shows the output directory where migration project files will be written on the computer running the graphical interface. The browse button presents the user with a dialog box to select this directory location. This directory represents the location where the MigrationProcess.db3 file is stored, this file contains information about the migration process for each table/file which is being migrated. If a selected directory already contains an existing MigrationProcess.db3 file, the yellow Continue... button is enabled.

Field: FileMaker App Name [MacOS X only]
Enter the name of the FileMaker application within the FileMaker App Name field - if AppleScript will be used to gather information from the source FileMaker database file(s). (if necessary). The name within this field should represent the name of the FileMaker application or stand-alone solution file as it appears within the Finder. In most cases, this field will not need to be changed. However if you desire to retrieve database structure information from a stand-alone FileMaker solution file, enter the Finder name of the solution in this field. FmPro Migrator uses this information to send AppleScript commands to FileMaker in order to retrieve the structure information from the FileMaker database. If you enter an invalid program name here, the Open Databases field will display "Compiler Error" after pressing the Refresh button.

Field: Open Databases
Open one or more FileMaker database files, then press the Refresh button. All of the FileMaker databases which are open will appear in the Open Databases field. There needs to be at least one database file open for the conversion process to be performed.
Note: You must have unrestricted access to the database (with no password required) in order for FmPro Migrator to read the database structure info from the FileMaker database.
FmPro Migrator also uses this field to display information for tables located within the Access or SQL Server database file referenced by the Source Database ODBC DSN.

Menu: Source Database
The source database may be a FileMaker, Access or SQL Server database. If Access is selected as the source database, then FileMaker 7 is automatically selected as the destination database.

Field: Source Database ODBC DSN
The source database ODBC DSN is used to query the source database in order to obtain database structure information. This info is first used to fill in the Open databases field [on Windows], and is then used to generate the ODBC DSN names used within the generated migration scripts for Access to FileMaker 7 and FileMaker to FileMaker 7 migrations. On MacOS X, this field is only visible when FileMaker 7 is selected as the source database.

Field: Source Db User
The Source dB User is used to log into the source database to obtain the database structure information. FileMaker 7+ creates a default user account named "Admin" whenever a new database is created.

Field: Source dB Password
The Source dB Password is used to log into the source database to obtain the database structure information. FileMaker 7+ creates a default user account named "Admin" whenever a new database is created, and by default this account does not have a password.

Menu: Destination Database
Select the database which will be the destination for the data.

Field: Destination dB User
The Destination dB User information is used to connect to the destination database, create/drop tables and transfer data from the source to destination databases. FileMaker 7+ creates a default user account named "Admin" whenever a new database is created.

Field: Destination dB Password
The Destination dB Password is used to connect to the destination database, create/drop tables and transfer data from the source to destination databases. FileMaker 7+ creates a default user account named "Admin" whenever a new database is created, and by default this account does not have a password.

Button: Continue...
Once info has been gathered from the source database, the yellow Continue button becomes visible. Click this button to open the Migration Process window and proceed to Step #2.

hline

. .

.

. .
 
 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact