Hi
Our Company has just bought the enterprise version. We have an SQL-Server database with all our servers (3000) with descriptions and groups. I would like to import and automate the process of sync with this database.
I'm a DBA so my prefered way is to write a Stored Procedure. But after Study the RDM Database i see it is mainly a Text-Column in the Connections Table, but it is in XML....
Which is the best way to do this? With the SDK?
Thank you very much
Best Regards
Andy
Hi,
I'm not a special list of SQL Server, but I think that the best way of doing that is by setting up the SQL Server replication.
There is also the Microsoft Sync Framework that might help:
http://msdn.microsoft.com/en-us/sync/default
All our record use a guid as a primary key, this will help you to sync the databases.
David Hervieux
Hi
Thank you for this quick replay. May i was not clear enough. I have a set of rules. These rules will search our database (in descriptions, services names running on the server, servernmames, groups, etc) and when match the server should be added to RDM (into a group and / or a template that is also definied in the rule).
So it is not a simple syncronisation. I'm study now your SDK 2.0. I'm not a programmer but i have spoken with one. He told me that he would make a DLL (and later a service that will run automatically).
It is possible with your SDK to add/modify/delete connections? Is it possible to add/modify/delete templates with the SDK?
I will have help from our programmer to implement this.
What don't unterstand is the meaning of having different shared templates.
Thank you
Andy
Hi,
I understand what you want, and for now there is no direct way of doing that. The SDK is to create new session type, dat asource type, tools type of import type. It's not to manipulate the content. This is something that we will eventually offers but we are nto here.
The only solution I see is to access the database from another tool and read the the data field with an xml parser. You can use a tool included in .NET named xsd.exe to generate a wrapper around the XML. If you haven't encrypted the data, you will be able to recognized the content.
David Hervieux