Thursday, November 12, 2015

Generic SQL Management agent released

Today is a big day for me...

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
The schema is very flexible and is generated based on the database tables definitions. A refresh of the schema for this management agent rediscovers the schema and you can override the structure in different manners using a configurable XML data.

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...

Enjoy,
Soren

2 comments:

Unknown said...

This looks great. Do you have any plans to extend it further? In particular I am interested in the possibility of using a separate pair of tables (single-value, multi-value) for each object type rather than having one large amalgamated table for all objects.

Søren Granfeldt said...

If it looks to be popular, I'll surely keep this project alive. And I may extend with the option you're looking for, but it is not planned for right now and my time is scarse right now :-)