SSIS Compare?
![mglenn](https://us.v-cdn.net/6029854/uploads/defaultavatar/nZUSABQN8JEE0.jpg)
Well it's mid-2008 and SQL Server 2008 will be released soon. Any word on whether there will ever be an SSIS 2005 Compare?
I supposed I could just compare the .dtsx XML files, but if the differences are scattered throughout it could be tough to decipher...
I supposed I could just compare the .dtsx XML files, but if the differences are scattered throughout it could be tough to decipher...
Comments
Sadly we have no plans to release an SSIS Compare tool at this point.
Thanks for the request.
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software
Thanks for the post. What would you be trying to achieve here?
David
Product Manager
Redgate Software
There would be 2 uses:
1) Documentation - document what objects a package uses without having to go through it. Yes, I know that the programmer/dba should maintain this, but as a consultant I often come into clients where no such documentation exists and we need to create it.
2) Troubleshooting - it would help when digging into a database and trying to figure out what's going on.
Thanks for drawing this use case to our attention.
Kind regards,
David
Product Manager
Redgate Software
The results wouldn't have to look exactly like the SSIS interface/BIDS.
At this moment, anything would be better than nothing
We haven't ruled it out, but it's not on the immediate roadmap. Is this more so you can compare or do you need this to deploy SSIS on different servers?
David
Product Manager
Redgate Software