Login

    Register

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.
Managed Hosting

PROJECT CATEGORIES

 

tableSnapshots
Project Home Screenshots Contact Project

Author: Brian Swartzfager (All RIAForge projects by this author)
Last Updated: December 4, 2011 4:17 PM
Version: 1.0
Views: 11,742
Downloads: 615
License: MIT

Description:

This tool, which will run on Adobe ColdFusion 8 and later, lets you do the following:

--Take a "snapshot" of one or more of your database tables, storing all of the current table data in a JSON file (NOTE: this tool will not work on tables with binary data fields).

--Replace the current data in a table with the data stored in a snapshot, creating a backup snapshot of the data being replaced in the process.

--View the data in a snapshot or backup snapshot in a jQuery-enhanced table that allows you to sort and filter the data.

--Delete older snapshot and backup snapshot files

A smaller, separate tool is also provided in the "tools" directory that will read the snapshot files into query objects.

The current version of the tool supports Oracle, MySQL, and Apache Derby databases, but you can add support for any additional databases by writing a single .cfc file.

Additional details and documentation can be found within the tool itself. To run the tool, simply unzip the files anywhere under the web root, open the main index.cfm file in a web browser, and read the main page of the tool.

Requirements:

ColdFusion 8 or higher
MySQL, Oracle, or Apache Derby

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.