Running manual queries

dbatools also has a command to run straight SQL, as follows:

# Plain Query
Invoke-DbaSqlQuery -SqlInstance serverinstance -Query 'SELECT foo FROM bar'

# From File
Invoke-DbaSqlQuery -SqlInstance serverinstance -File . ebuild.sql

It also supports using advanced options such as Sqlparameters.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.138.122.4