How can I execute SQL scripts using TeamCity?

luisen Published at Dev

luisen

I´m new with TeamCity and I don´t know how to run SQL scripts with it.

Is the way simply selecting the path of those scripts in a Command Line Build Runner ?

I´m pretty lost.

Regards.

John Hoerr

In a command line build step:

Command executable: c:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqlcmd.exe Command parameters: -S <server> -i <path_to_file> <== Note: that's a capital -S!

You may need to change the 100 to something else, depending on the version of the SQL Server tools that you have installed on the build agent.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-12

Comments

0 comments

how i can execute scripts of multiple classes in xml file using TestNG frame work

How can I execute groovy scripts in an isolated classloader?

How can I execute this sql statement with .NET and Dapper.NET?

How can I execute Selenide in Chrome using ChromeDriver

How can I execute SQL scripts using TeamCity?

How can I execute SQL scripts using TeamCity?

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

grouping by column variables and appending a new variable based on condition

Vector input in shiny R and then use it

Can a 32-bit antivirus program protect you from 64-bit threats

Python Read Directory And Output to CSV

Remove adjacent duplicates in linked list in C

Angular 8. Unknown amount of http.get requests in array to call, must be sequential, what to use

Json Schema - Conditional Evaluation with RegEx

Getting 502 Bad Gateway Error While Deploying WordPress On Dockerized Lemp?

JMeter: Why get error when try to save test plan

Group boxplot data while keeping their individual X axis labels in ggplot2 in R

How to how increase/decrease compared to adjacent cell

How to keep curl session alive between two php processes?

In Pandas UnicodeDecodeError Cannot decode Unicode Ascii in JSON file using pandas.read_json()

MTKView Displaying Wide Gamut P3 Colorspace

BigQuery - concatenate ignoring NULL

Error in v-on handler (Promise/async): "TypeError: Cannot read property 'data' of undefined" // undefined

An unhandled exception occurred: Collection "@angular/material" cannot be resolved

How to call angular controller scope function from directive with parameters?