For a long time now, I've wanted to build a new SQL Management that could do more than the built-in SQL Server Management Agent that you get out-of-the-box with FIM and MIM. And, finally, I have done just that.
It is here....
By using this generic Management Agent for SQL, you can synchronize almost any type of information with SQL Server tables - and now you can finally do deltas as well ...and hold on, you can run stored procedures against the tables as part of your synchronization import and export schedules. All these tings combined should give you the options to make some awesome solutions with FIM/MIM and SQL.
The MA have a lot of features that are needed for a modern FIM2010 or MIM2016 setup, including -
- Full and delta imports
- Delta and full exports
- Can keep and revive deleted information / rows
- Can execute pre- and post import/export Stored Procedures
I really hope that you make use of this MA and please let me know if there are any issues as this is the initial release - and I'll try to fix any issues as soon as possible.
You can get it on CodePlex from this URL - https://sqlma.codeplex.com/
Go it a go when you can...