Activity overview
Latest activity by rwillemain
Thank you very much for the query to derive thsi information.
It is appreciated and vgery useful.
Sincerely, Rick / comments
Thank you very much for the query to derive thsi information.
It is appreciated and vgery useful.
Sincerely, Rick
Hello Sir, Thank you fro replying. I missed the original msg, sorry. We have a 3n tier infrastructure for our sql servers - mostly SS_2000. For both jobs and DTS packages we need to track and document differences as chnages occur fron dev-test tier on up the stack.
Is the tool you ref. available for us to use ?
Kind regards, Rick Willemain
David Atkinson wrote:
We have a tool that can compare DTS packages linked from labs.red-gate.com
However, this doesn't compare SSIS packages.
SQL Compare doesn't currently compare Jobs, although this is something we could consider in a future version. Can I ask what you are trying to achieve?
Kind regards,
David Atkinson
Red Gate Software
/ comments
Hello Sir, Thank you fro replying. I missed the original msg, sorry. We have a 3n tier infrastructure for our sql servers - mostly SS_2000. For both jobs and DTS packages we need to track and docu...
COMPARE to include collation info ?
Perhaps I am looking in the wrong places, but to compare two databases for differences in collations, where can I find this, if possible ?
Thsnk you. Rick
DTS and sql job compares
I searched all forums here, on DTS and data trasnformation service and get thousand of returns, but in all the messages checked, none have anything to do with DTS or jobs at all.
Sorry if I am maki...
Status of trigger : enabled / disabled
In a comparison of what are identical dbs, I can see triggers as such, but in no apparent way can I determine if there are enabled or disabled.
Bummer ! Missed a big problem in this case ... Any...