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

PowerShell 5.0 Management Agent released

I'm very pleased to announce that version 5.0 of my PowerShell Management Agent is released and available for download.

This new version includes these key improvements -

• Additional control values on your import and export return objects
• Ability to returned datasource constructed anchors, i.e. from Office 365 and SQL server
• Option to use paged imports, which gives you even more control in your scripts and better support for stopping runs.
• Bug fixes and increased robustness.

I'm not going to spend a whole lot of time on these new features but instead than refer you to the updated online manual which also has links to downloads. Also, this version was the one used at my presentation and live demo on the FIM Team User Group meeting. You can view it here on YouTube.

I'd like to hear from you - good or bad news - and I'm of course always open to feature requests. So please do let me know what you think about this MA and I also very much appreciate a "Like" on my blogs page on Facebook.

Happy PowerShell'in...