January 5, 2018 at 5:03 am
Is there an enterprise tool to perform assessment of a huge database stack with SQL Server, Oracle, MYSQL, DB2 etc databases in the portfolio. The requirement is to do a quick assessment of databases and generate a report of their cloud up gradation readiness/feasibility.
Even if I am just able to do some discovery of database versions, configurations etc, that would help
January 5, 2018 at 6:27 am
Benki Chendu - Friday, January 5, 2018 5:03 AMIs there an enterprise tool to perform assessment of a huge database stack with SQL Server, Oracle, MYSQL, DB2 etc databases in the portfolio. The requirement is to do a quick assessment of databases and generate a report of their cloud up gradation readiness/feasibility.Even if I am just able to do some discovery of database versions, configurations etc, that would help
What I normally do is to collect as much information as possible by running scripts against all known database servers, import into a database and finally use the likes of PowerBI to analyze the data. This is not a trivial process and you can expect to spend 1-2 weeks at least per 1000 databases. There are several hundred variables that might affect the upgrade readiness and feasibility, some more important than others of course.
😎
How many servers and databases are in the estate? Are there many different versions and editions of each type? Is this all production or are you also including development/testing?
January 5, 2018 at 6:35 am
Eirikur Eiriksson - Friday, January 5, 2018 6:27 AMBenki Chendu - Friday, January 5, 2018 5:03 AMIs there an enterprise tool to perform assessment of a huge database stack with SQL Server, Oracle, MYSQL, DB2 etc databases in the portfolio. The requirement is to do a quick assessment of databases and generate a report of their cloud up gradation readiness/feasibility.Even if I am just able to do some discovery of database versions, configurations etc, that would help
What I normally do is to collect as much information as possible by running scripts against all known database servers, import into a database and finally use the likes of PowerBI to analyze the data. This is not a trivial process and you can expect to spend 1-2 weeks at least per 1000 databases. There are several hundred variables that might affect the upgrade readiness and feasibility, some more important than others of course.
😎How many servers and databases are in the estate? Are there many different versions and editions of each type? Is this all production or are you also including development/testing?
About 5000+ databases. Comprising of various flavours of databases like SQL Server, Oracle, DB2, MYSQL etc with many different versions. Prod test dev everything included.
Now, a bad questions. Are there generic scripts that will help me query most of the RDBMS guys 😛
January 5, 2018 at 6:48 am
Benki Chendu - Friday, January 5, 2018 6:35 AMEirikur Eiriksson - Friday, January 5, 2018 6:27 AMBenki Chendu - Friday, January 5, 2018 5:03 AMIs there an enterprise tool to perform assessment of a huge database stack with SQL Server, Oracle, MYSQL, DB2 etc databases in the portfolio. The requirement is to do a quick assessment of databases and generate a report of their cloud up gradation readiness/feasibility.Even if I am just able to do some discovery of database versions, configurations etc, that would help
What I normally do is to collect as much information as possible by running scripts against all known database servers, import into a database and finally use the likes of PowerBI to analyze the data. This is not a trivial process and you can expect to spend 1-2 weeks at least per 1000 databases. There are several hundred variables that might affect the upgrade readiness and feasibility, some more important than others of course.
😎How many servers and databases are in the estate? Are there many different versions and editions of each type? Is this all production or are you also including development/testing?
About 5000+ databases. Comprising of various flavours of databases like SQL Server, Oracle, DB2, MYSQL etc with many different versions. Prod test dev everything included.
Now, a bad questions. Are there generic scripts that will help me query most of the RDBMS guys 😛
From the top of my head (SQL Server focused)
😎
Each of the RDBMS's has its method of collecting those information, any proper DBA would know how to do that on his platform😉
January 5, 2018 at 6:49 am
There is, or at least was, a free tool from Microsoft that can help in discovering all SQL installations, have not used it in years but it is used in MS true up inventories. If you have full domain rights this will help, otherwise speak to your network guys or whoever is responsible for licensing. I cannot give you a link as am constrained be mobile!
This may not give you the actual databases but again there is another me tool which should help there.
...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply