HOW DO YOU MIGRATE? FileMaker Migration Assistant Tool vs. Manual: Best Practices to Migrate Changes to a Live FileMaker Server | 360WorksBy 360Works
FileMaker Migration Assistant Tool vs. Manual:
Best Practices to Migrate Changes to a Live FileMaker Server
Tips from 360Works Senior Developer and Product Manager, Joe Martin
In the past, FileMaker developers haven't had many options for rolling out new changes to their live databases. Even if you were cautious, and did your development in a separate Dev copy of your production file, it was difficult to migrate these changes to your production file.
You could roll your own deployment workflow, scripting FileMaker imports for each table in your solution, and update this workflow whenever you added new tables or fields. These imports are slow and tedious though, and most of us would simply make the changes directly in the live file.
With the release of FileMaker 17, FileMaker came out with the FMDataMigration tool, completely replacing the need for using FileMaker native imports to move your data around. Here at 360Works, we built 360Deploy around the FMDataMigration tool to streamline and completely automate its use, making development changes a tedium free experience.
In today's article, we will walk you through how to do both options so you can determine which is right for you.
See the Article Now
Stay updated with 360Works
General Questions: plugins@360Works.com
Need Support? Email: support@360Works.com
Just want to know more about 360Deploy? Skip the article. Product page here: https://www.360works.com/filemaker-deploy-versions/
Complete list of ALL the things 360Works has to help your FileMaker Development here: https://www.360works.com/products/
New Update: Zulu 3.1
We recently released an update with improvements for our FileMaker Calendar Sync Tool, 360Works Zulu.
Zulu integrates FileMaker with Apple, Google, and Exchange Calendars.
It is easy to install. There are no scripts to edit or files to modify. Simply run the installer, walk through the configuration process, and publish your calendar.
Sync your application events with ease.
This is a free update for Zulu 3 users with active maintenance for Zulu or the Portfolio Bundle! Maintenance is active for one year from date of purchase or one year from date of maintenance renewal purchase. If you need a new license or have a license with expired maintenance and wish to use Zulu 3, you can purchase a new license at the Zulu product page.
Never tried Zulu? You can download a free demo license, also available at the Zulu product page. While in demo mode, the product will run for 2 hours every time you launch FileMaker.
List of improvements:
Added Minimum Start Date for Exchange Calendars Improved audit log during startup Improved conflict management when syncing to Google and Exchange Calendars
Better sync data recovery on startup Fixed an issue when updating parent events with child exceptions Multi day events are better handled in Apple Calendar GET ZULU 3.1 NOW 360Works, over 20 FileMaker Plug-ins and Developer Tools!
Questions? Email firstname.lastname@example.org
Tech Support? Email email@example.com
Hi. I had a really weird problem last night that was pervasive through all files I was working on, served, local, and even a new file I created to try to test the issue. It was totally crippling and driving me crazy. I had gone into a script and selected the Go to Layout command, but when I tried to select a layout, none appeared, even though there were plenty of layouts in the table. I dismissed it as a temporary glitch and tried a Set Field command, needing to set a field to a calculation, and again, found the system locked up in such a way as I had never seen before. It would not let me enter a calculation! I closed and re-opened the file. No dice. I restarted Filemaker. Nope. I rebooted my entire computer. Nope. I tried working on a local file. Still - no layouts could be chosen in ANY file! I tried making a *new* file. Nope! I was desperate, and just about posted asking for help when I thought to disable all plug-ins, just to make sure, and voila - that did it. As soon as I disabled the 360Works FTPeek and 360Works WebAssistant plugins, full functionality in the script workspace was restored! I thought maybe it was just a coincidence. I re-enabled the plug-ins and checked again. It still worked, with the plug-ins re-enabled, so - maybe I was just having a bad day, but then when I went back in this morning, again - with the plug-ins re-enabled, again - I couldn't select any layouts or make any calculations in Script Workspace, so right away I disabled the plug-ins, again, and again, that fixed it, so I'm pretty sure there's something going on with the plug-ins. I also had 360Works Email installed, but had disabled it the day before any of this started to test functionality on the server, so that one was never enabled, and that's probably the first time I've ever disabled that one while still having the other's enabled. Other than that, I haven't changed anything about my system for quite awhile. I'm actually running 16, so maybe this won't be a problem when we upgrade to 17, but for anyone else who hits this roadblock - disable your plug-ins.
360Works has just released 360Deploy 2.6 with several improvements to the software performance.
360Works provides outside-the-box innovation, so you can be the genius FileMaker developer at work while using the most robust, innovative development tools you need to get the job done.
360Deploy is a FileMaker deployment tool, designed to make FileMaker data migration easier. It utilizes the FileMaker Data Migration Tool, but it is so much more than only a wrapper for the FileMaker DMT and costs less than other automation software, with no annual cost. It completely automates the tedious data migration tasks, while pushing changes from the development environment to the production server making it the ultimate FileMaker migration assistant!
What's New in 360Deploy 2.6?
Server addresses with custom ports are better handled Multiple deployments to the same server will have more consistent results Improved connection performance for clients 32-bit windows machines now launch the plugin more smoothly
Download 360Deploy 2.6
How Does 360Deploy Work?
Clones the development database Transfers clone to the production server Imports the data from the production database and into the clone to absorb the new architecture *For large databases, it supports a scheduling feature to run imports overnight. Backs up the production solution in archived folders prior to import should clients wish to revert back to the old version Renames the deployed file Resumes the deployed file
Keep in mind, once you press the 'deploy' button in 360Deploy, there is nothing left to do. It sends the new version to FileMaker Server (or multiple servers), and then runs in the background on each server, so you are free to continue working, take a break, or head home for the night, knowing that the new version will be safely deployed to users on each server by the time you get back. You'll receive an email when the process is complete. Skip the hassle of fumbling with files on the server and stick to the 'one-button click' of 360Deploy for dev changes.
Download 360Deploy 2.6 Compatibility
360Deploy 2 requires FileMaker Pro or Advanced 16, and production databases must be hosted on FileMaker Server 14 or later.
After downloading 360Deploy on your server and configuring settings with the simple 360Deploy Setup utility, 360Deploy will deploy the development file changes to your users with the click of one button.
360Deploy 2.6 is a free upgrade for 360Deploy 2 license holders, which is a huge benefit of maintaining the latest version of 360Works software.
If you do not have a license, 360Deploy 2 is available immediately for purchase at the 360Deploy page. Pricing starts at $195, which includes deployment with a single FileMaker solution (this can be a multi-file solution) and a single production server. It allows updated file versions for one solution to be deployed to one live / production server.
Additionally, there is a free demo license available which can deploy to any number of servers for testing and evaluation purposes. Higher grade license types are available for purchase as well.
Located in metro Atlanta, 360Works, a FileMaker Platinum Business Alliance member, has been providing development solutions for over 22 years. The company is a leading developer of both shrink-wrapped and custom database solutions for clients such as NASA, Pixar, US Marines, Make-A-Wish foundation and others. The company is credited for its forward-thinking solutions, dedication and unparalleled client service.
Missed our last update? Check out this video below for an up-to-date tutorial on 360Deploy 2!
Download 360Deploy 2.6