Ben Miller (DBAduck)


Stairway to SQL PowerShell

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.

4 (1)

2021-12-08 (first published: )

12,406 reads

Blogs

Daily Coping 5 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

New Database Job – Understand What You Have

By

In my previous post, I expounded on my first 30 days I had at...

Daily Coping 4 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Designing a table

By Johnson330

Hi, I have this list of training courses: Course_Code|Description 1 |Health and Safety 2...

Multiple Fact Tables

By yrstruly

Please assist? I would like to do a data model of the tables here:...

Drop database on Secondary Node from Primary for automatic restore job

By dennis.miller 20021

hi all We've ventured into the world of AAG's as we have now moved...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers