Synchronizing Databases

If you've ever needed to synchronize databases, you know how tedious this can be. Opening each table in design view and comparing the columns visually. I've personally done this hundreds of times. I create a simple CFM file that accepts 2 datasources, a source and target, and compares the columns. It's easy to use, free, and the installation is simple. Just unzip the download and place in a directory accessible through your web server.

Requirements:

• Coldfusion 6 or higher or Railo
• SQL Server 2000 or higher

Click here to view an example

Click here download

EasyCFSQL

Tired of writing SQL. Stop! Have ColdFusion write your SQL for you.

This is a small script that utilizes the system tables of a MS SQL Server database to loop through the user tables and columns to display select, insert and update statements inside a cfquery.

Click here to view an example

Click here to download

Good Coding!