February 6, 2012
Gary posted recently on Automating Deployment For Clarify. A customer recently had an automation need that I answered in a similar way but rather than using NAnt I pulled from our fancy favorite new build automation tool Rake. In this post we’ll take a look at automating common database setup tasks like applying schema scripts and executing arbitrary SQL using Rake. I hope you find it useful. Where is the Code? I put together a Dovetail Automation gist with everything you need to solve two problems. Applying Dovetail Schema Editor schema scripts. Applying all SQL scripts in a directory. Check out the readme for setup and execution instructions. Next I’ll talk a little about what each task does. Applying Schema Scripts (apply_schemascripts) This task looks for a child directory named schema below where the rakefile.rb is located. Every file in…
Automating Deployment For Clairfy Using Rake
February 6, 2012
Gary posted recently on Automating Deployment For Clarify. A customer recently had an automation need that I answered in a similar way but rather than using NAnt I pulled from our fancy favorite new build automation tool Rake. In this post we’ll take a look at automating common database setup tasks like applying schema scripts and executing arbitrary SQL using Rake. I hope you find it useful. Where is the Code? I put together a Dovetail Automation gist with everything you need to solve two problems. Applying Dovetail Schema Editor schema scripts. Applying all SQL scripts in a directory. Check out the readme for setup and execution instructions. Next I’ll talk a little about what each task does. Applying Schema Scripts (apply_schemascripts) This task looks for a child directory named schema below where the rakefile.rb is located. Every file in…
January 11, 2012
Last year I posted about automated deployments for Clarify. From that post: Doing automatic deployments of Clarify changes is pretty straightforward. If I was starting off, I would use a contemporary build script tool such as nant or rake, and simply have it call out to your schema editing tool (Dovetail SchemaEditor, or ddcomp) to perform schema changes, use an import tool (such as Dovetail ArchiveManager, or dataex) for importing forms, and then compile your Clearbasic code using CBEX, or just import it as a DAT file using Dovetail ArchiveManager. File copying, registering components, configuring web servers, and setting permissions are all common tasks that are available in these build tools as well. Should you also need to do additional stuff in your database, some code that uses the Dovetail SDK can be useful. You could tie this…