March 12, 2014 at 11:39 am
I'm looking for an SSIS project or freeware tool to connect to different SQL Servers (based on a table that contains the list of WindowsServerNameS, SQLServerInstanceNames) and then retrieve metadata and diagnostic information on those databases. Information such as size, collation, configurations of each databases in each Instance, list of all tables and their rowcounts, table schemas for each table in those databases. That's not an exhaustive list but just a start.
Something even with a subset of these features would be great. Does something like this exist?
March 12, 2014 at 11:55 am
It depends on what automation and instrumentation method you're wanting to inegrate with.
It will require some programming, but PowerShell is typically used for what you're asking. This is perhaps the most flexible solution.
However, if it were me, I'd tend to go the route of registering a SQL Server Group in SSMS, which allows you to run a query across multiple instances in much the same way it works with a single instance. I'd then insert and archive the results in a table.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply