You should be able to pull off any database maintenance using CF programming. However, you may wish to consider buying a tool that already does this. It would save you a lot of time. Creating code that intelligently updates a production database can get ugly because there are so many elements that you have to watch out for (primary keys, data types, indexes, constraints, data)
Red Gate makes some decent sync software that you could probably fire off with a CF script. http://www.red-gate.com/sql/summary.htm I would not want my production database automatically altered by CF code that was written by someone who lacks a thorough understanding of the internals of SQL Server. Synchronizing data is one thing, updating the structure is much more involved. Good luck, Mike Chabot ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2198 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
