We need to be able to use the output of the Data Compare Tool in a MS Installer package which begins to become unreliable when any script goes over about 1.5MB.
Considering that your tool might create a 200MB script for each of 30 databases we maintain and the contents of these changes regularly, the process is now:
- - For each of the 30 databases
- - Create the 200MB script file (your product makes this easy)
- - Manually split it into 80 or so SQL script files (takes a very long time)
- Have the installer call each of the 80 pieces (which will probably not be avoidable, but at least we can use naming conventions to reduce this a little)
30 * (a very long time) * (something that happens regularly) = unmanageable
Is there either a way to have the Data Compare Tool create the 80 small files automatically or does anyone know of a tool that can reliably break one of these monsters into a bunch of manageable scripts that can be used in an MSI installer?