Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Common Resource: Invoke-Query #1355

Closed
kungfoome opened this issue May 3, 2019 · 0 comments · Fixed by #1380
Closed

Common Resource: Invoke-Query #1355

kungfoome opened this issue May 3, 2019 · 0 comments · Fixed by #1380
Labels
enhancement The issue is an enhancement request.

Comments

@kungfoome
Copy link

kungfoome commented May 3, 2019 •
edited
Loading

It doesn't appear there is way to pass in all the same parameters as connect-sql. So if I wanted to connect using sql credentials or windows, I wouldn't be able to that with invoke-query

$serverObject = Connect-SQL -ServerName $SQLServer -InstanceName $SQLInstanceName

Also the parameters differ from Connect-SQL, can we create alias ServerName and InstanceName of Invoke-Query
@kungfoome kungfoome mentioned this issue May 3, 2019
Closed
9 tasks
@johlju johlju added enhancement The issue is an enhancement request. in progress The issue is being actively worked on by someone. labels May 3, 2019
@kungfoome kungfoome mentioned this issue Jun 24, 2019
Merged
9 tasks
johlju pushed a commit that referenced this issue Jun 30, 2019
@johlju
Invoke-query updated to allow smo object (#1380)
943c878 
- Changes to common module: Invoke-Query
  - Fixes issues in [issue #1355](#1355)
  - Works together with Connect-SQL now
  - Parameters and Aliases now match that of Connect-SQL
  - Can now pass in credentials
  - Can now pass in 'Microsoft.SqlServer.Management.Smo.Server' object
  - Can also pipe in 'Microsoft.SqlServer.Management.Smo.Server' object
  - Can pipe Connect-SQL | Invoke-Query
  - Added default vaules to Invoke-Query
@johlju johlju removed the in progress The issue is being actively worked on by someone. label Jun 30, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement The issue is an enhancement request.
Projects
None yet
Milestone
No milestone
2 participants
@kungfoome @johlju