Inventory to database tables

Feb 25, 2014 at 8:57 AM
Hi, I would like to get the results of this tool into database tables, so that I can exploit it for other purposes in my management : login copy from a server to another, permission copy and other points like that.

Is there somebody who can help ?
Coordinator
Mar 5, 2014 at 8:23 PM
Currently there is nothing built into SQL Power Doc to persist the results to a database. It's on my to-do list at some point in time but with so much information collected I'm not sure what the schema that holds it all would even look like.

For copying logins from one instance to another have you seen (http://support.microsoft.com/kb/918992?

--Kendal
Mar 5, 2014 at 9:36 PM
Hi Kendal, I know there are some parts of tools that are implemented for copying logins. But my idea is a little bit further in depth : for a login, you have a user that is mapped. You can have permissions, group membership at login, or at user level.
One of the actions I would like to do in a « single click » is to copy all the security related informations for a particular login / user and apply it elsewhere. The same kind of operation could be done for instance for sql agent jobs with their schedule
and so on. Another point for me is to constitute a « documentation/repository », which would be firstly based on this inventory. Building up the inventory from time to time would simple be the checking of differences between current inventory and the documented
inventory. This way, I have almost everything under control… Best regards, Jefferson Elias.
Sep 26, 2014 at 4:41 PM
Hi Jefferson,
For copying Jobs and Logins from one server to another, you can use SSIS package. There is a good article explaining this http://www.mssqltips.com/sqlservertip/2081/transfer-sql-server-jobs-task-and-transfer-sql-server-logins-task-in-ssis/
I hope I understood correctly.

Best, -Anil