How to execute .sql file using powershell?

by

Try to see if SQL snap-ins are present:

get-pssnapin -Registered

Name        : SqlServerCmdletSnapin100
PSVersion   : 2.0
Description : This is a PowerShell snap-in that includes various SQL Server cmdlets.

Name        : SqlServerProviderSnapin100
PSVersion   : 2.0
Description : SQL Server Provider

If so

Add-PSSnapin SqlServerCmdletSnapin100 # here lives Invoke-SqlCmd
Add-PSSnapin SqlServerProviderSnapin100

then you can do something like this:

invoke-sqlcmd -inputfile "c:\mysqlfile.sql" -serverinstance "servername\serverinstance" -database "mydatabase" # the parameter -database can be omitted based on what your sql script does.

More Related Contents:

  1. Case statement for multiple columns
  2. SQL where clause odd behavior [closed]
  3. SQL Server Exec issue [closed]
  4. How do I obtain a Query Execution Plan in SQL Server?
  5. Count(*) vs Count(1) – SQL Server
  6. Selecting data from two different servers in SQL Server
  7. Is a view faster than a simple query?
  8. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  9. SQL Server: Make all UPPER case to Proper Case/Title Case
  10. How do I delete from multiple tables using INNER JOIN in SQL server
  11. Does Foreign Key improve query performance?
  12. SQL : BETWEEN vs =
  13. What is a ‘multi-part identifier’ and why can’t it be bound?
  14. SQL Server convert string to datetime
  15. Should I design a table with a primary key of varchar or int?
  16. How do you import a large MS SQL .sql file?
  17. How do I make a composite key with SQL Server Management Studio?
  18. Difference between Subquery and Correlated Subquery
  19. Count based on condition in SQL Server
  20. Does Sql JOIN order affect performance?
  21. Syntax of for-loop in SQL Server
  22. Using tuples in SQL “IN” clause
  23. Why does ISNUMERIC(‘.’) return 1?
  24. How do you copy a record in a SQL table but swap out the unique id of the new row?
  25. SQL Server SELECT INTO @variable?
  26. Select a column if other column is null
  27. How to subtract 30 days from the current date using SQL Server
  28. Use one CTE many times
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment