Skip to content

Instantly share code, notes, and snippets.

@nvarscar
Created January 24, 2019 17:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nvarscar/08fd4e73b9ba9891ba847f67fc33cde0 to your computer and use it in GitHub Desktop.
Save nvarscar/08fd4e73b9ba9891ba847f67fc33cde0 to your computer and use it in GitHub Desktop.
# install a DBOps package to the MySQL server
Install-DBOPackage -Type MySQL -Server localhost -Database mydb -Path .\package.zip
# invoke a query against a remote PostgreSQL server
Invoke-DBOQuery -Type PostgreSQL -SqlInstance pgsql1:5432 -Database mydb -Query 'SELECT current_database();'
# change the default connection -Type (SQLServer) to PostgreSQL:
Set-DBODefaultSetting -Name rdbms.type -Value 'PostgreSQL'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment