![]() If the data transfer process fails, an error message will be displayed containing the text of the error message returned by the destination database. Once the data has been transferred successfully, the status menu below the Step 4 Transfer Data button will change from "Not Started" to "Completed". ![]() Holding down the shift key while clicking the Step 3 Create Table button drops and re-creates the table in the Valentina database.Ĭlick the Step 4 Transfer Data button to transfer data from the source table in the FileMaker database to the newly created table in the Valentina database. Once the table has been successfully created, the status menu under the Step 3 Create Table button will be changed to "Completed". The status will be set to "Failed" if the Get Fieldsize step fails for some reason.ġ) Check to make sure that the source database is open within FileMaker Pro/Advanced on the local computer.Ģ) Make sure that ODBC sharing is enabled.ģ) For FileMaker 7+ databases, make sure that there is a TO on the RelationshipGraph which exactly matches the name of the base table being queried by FmPro Migrator.Ĥ) Open the Define/Manage Database dialog and verify the existence of the base table within the FileMaker Pro database.Ĭlick the Step 3 Create Table button to create the table in the destination database.įmPro Migrator will generate the table creation SQL code, connect to the Valentina database and create the table. After the records have been successfully read from the table, the status menu at the bottom of the Step 2 button will change from "Not Started" to "Completed". FmPro Migrator will make an ODBC connection to the source FileMaker Pro database, and put up a progress dialog as it is reading thru the records. The results are then stored within FmPro Migrator's embedded database for used in Step 3 when the table creation SQL code is generated.Ĭlick the Step 2 Get Fieldsize button. Since there is no command available within FileMaker Pro for determining the maximum size of each field, FmPro Migrator reads every record from the table in order to make this calculation. This information is then used to automatically build the table creation SQL code for the Valentina database. In order to properly create the table in the Valentina database, FmPro Migrator needs to figure out the maximum amount of data stored in each field within the FileMaker Pro database table. ![]() These fields represent the info gathered from the source database by FmPro Migrator. Once a table is selected, a list of fields contained within the table will be displayed in the Fields list. ![]() All of the remaining migration tasks will be performed from this window.Ĭlick on a table in the Tables list. button, the Migration Process window will be displayed. Clicking the Continue button opens the Migration Process window where you will continue the migration process.Īfter clicking the yellow Continue. button will become visible once FmPro Migrator has completed processing the Table XML from the ClipBoard. Within FmPro Migrator, click the Step 1 Get Info button (with the ClipBoard XML menu option selected). Click the Cancel or Ok buttons to close the Define/Manage Database dialog. Once the Table XML info has been put onto the clipboard, the Paste button will become active. (1) Select all of the tables on the Tables tab, (2) click the Copy button. This process copies all of the Table/Field definition info from FileMaker Pro Advanced, puts the info onto the clipboard from Manage Database dialog. fp7 database file using FileMaker Pro Advanced. To summarize the process here, I will just use the Table XML method to gather info from the. The detailed PDF is close to 100 pages long, as it covers all of the various Get Info processing step options, and ODBC driver installation steps on both Mac OS X and Windows platforms. There are multiple ways to get the schema info from FileMaker Pro databases, which is covered in detail in the How to Migrate FileMaker Pro to Valentina PDF file on the website. The first step in performing any FileMaker Pro database migration is to get schema info about the FileMaker Pro database. The second in a tutorial series showing you how to use the newly released FMPro Migrator 4.74 to move your database to Valentina.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |