What is PowerShell?
- Replacement for VB Scripting and Command Prompt
- A task automation and configuration management tool for IT professionals
- An interactive object-oriented command environment with scripting language features utilizing small programs called cmdlets
- Simplifies configuration, administration and management of heterogeneous environments
- Standard-based remoting protocols
- Object based extensible scripting solution integrated into Windows OS
- Great for IT professionals who do not have time and need to simplify.
Why Use PowerShell for DB Management?
● Lightweight tool to manage simple database operations
● Utilize the power of .NET
● Not GUI
● Lack of command line scripting for Oracle database management in Microsoft
● Database task automation without having to use a batch file, job, etc
● DBAs typically manage multiple databases (Oracle, SQL Server, MySQL)
● Lightweight tool to manage simple database operations
● Utilize the power of .NET
● Not GUI
● Lack of command line scripting for Oracle database management in Microsoft
● Database task automation without having to use a batch file, job, etc
● DBAs typically manage multiple databases (Oracle, SQL Server, MySQL)
