PowerShell to Create table on sql databse in multiple instance.

All replies

• 

  

  0

  Sign in to vote

  Writing SQL scripts is not supported in this forum.  Post in SQLServer forum for hep with SQL.

  You can use SMO or just ADO.Net but you will have to learn PowerShell first.

  If you have written a script then post it with specific errors or a specific question.

  Please carefully review the following links to set your expectation for posting in  technical forums.

  This Forum is for Scripting Questions Rather than script requests

  • Script Gallery.
  • Forum for Script requests
    1. Microsoft Virtual Academy - Getting Started with Microsoft PowerShell
    2. PowerShell Documentation
    3. PowerShell Style Guidelines
  • How to ask questions in a technical forum
  • Rubber duck problem solving
  • How to write a bad forum post
  • Help Vampires: A Spotter's Guide
  • This forum is for scripting questions rather than script requests

  ---

  \_(ツ)_/

  
  

  • Edited by jrv Thursday, November 15, 2018 10:40 AM

  Thursday, November 15, 2018 10:40 AM
• 

  

  0

  Sign in to vote

  Here is a  basic template for using SQL to create tables.

  $servers = 'server1','server2','server3','server4'
  $sql = @'
  USE mydatabase;
  CREATE TABLE Persons (
       PersonID int,
       LastName varchar(255),
       FirstName varchar(255),
       Address varchar(255),
       City varchar(255) 
   ); 
  '@
  
  foreach($server in $servers){
      Invoke-Sqlcmd -Query $sql -ServerInstance $server
  }

  
  

  ---

  \_(ツ)_/

  
  

  • Edited by jrv Thursday, November 15, 2018 11:01 AM

  Thursday, November 15, 2018 11:00 AM