Hello, I was wondering if Redgate has a tool that will essentially create a synchronization scipt on the fly? What I mean by this is assume my company has released v1.0 of product A. It is now 6 months later and we want to release v1.1 of product A. During the past 6 months, some customers have had patches or hotfixes applied that contain updates to the database, some have not. What I am looking for is a tool that will essentially analyze the database that is presently on the target computer and create the appropriate update script based on the differences between what is presently installed and the changes that were made to the v1.1 database.
Any help would be appreciated!