Feature Inquiry

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » Feature Inquiry

Feature Inquiry

Rate Topic

Display Mode

Topic Options

Author

Message

Jarthda

Posted Monday, March 11, 2013 5:14 PM

Valued Member

Group: General Forum Members
Last Login: Friday, March 15, 2013 11:32 AM
Points: 51, Visits: 11

Hello,
Does 2012 offer any feature which allows for the collection of Instance data across all my production installs? In other words, what is a good technique to centralize (for documentation)

All SSIS package (document only)
All Jobs and scheduales
All logins and database mappings
Instance configuration parameters

I can write SQL queries and run them on each server and centralize them manually...or I can deploy procedures an maintain those across all instances. But I'd like to do this with as little footprint as possible. Preferable none.

What I'd like, is a feature where one of my instances is a repository and collects this information from the servers I choose. Does this make sense? How are people doing this and is there something in 2012 to help.

Post #1429542

« Prev Topic | Next Topic »

Permissions