June 30, 2006 at 8:40 am
All
A DBA at the sister company is convicned that the IDERA toolset is going to solve all of his problems. He wants to order Compliance manager (aduiting), Config Manager (migration), and Performance Manager.
Any one have any experiance with these tools?
Anyone Recommed any other tools to solve the same problems for less than the 6K price on these tools?
Thanks in Advance
Eric Peterson
June 30, 2006 at 8:54 am
Not an expert at all, just some observations (I'm new to this, so they're probably not the best observations. . . hope this helps some)
In terms of auditing, I am also considering several solutions, but I am leaning towards Lumigent's solution (Entegra, I believe), although IDERA runs a close second for me (it falls short only in not allowing loading of old transaction logs, as far as I can tell - let me know if you see that it can do this, please)
Not sure if this helps you in the price department as I believe that Entegra is fairly pricey. If you're running SQL Server 2005 and your auditing requirements are not terribly strict (and you have some disk space to spare) you can set up a default audit trace that will save to disk and give you the same basic information as when you run SQL Profiler (in fact, the traces will load into Profiler, and from there you can do some basic searches or load into a table).
Migration - I have done this several times, and probably not the "smart" way, necessarily, but (again, depending on which version you're running) I believe that SSIS has some fairly advanced solutions to offer in terms of server login transfer (or you could use sp_helprevlogin) and transfer the databases themselves using backup/restore or simply detach, copy, and attach, depending on your situation.
-- http://dbachman.blogspot.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply