How to run SQL Script from a particular folder using Command Prompt


To run SQL Script stored in a particular folder using Command Prompt:


REM - Run SQL Script to prepare the database environment

 ECHO Preparing Databases...

 SQLCMD -E -i C:\ETL_Solution\SetupFiles\Setup.sql

Comments

Post a Comment

Popular posts from this blog

Request failed with HTTP status 503 Server Error

Image
Problem: When 100's of users ae trying to access Reporting services report then, SSRS throws error as below : "Request failed with HTTP status 503 Server Error" and how to resolve this error Solution: From experience, this issue can be caused by multiple reasons Problem might be related to: 1 - TCP/IP Port Exhaustion: When a client initiates a TCP/IP socket connection to a server, the client typically connects to a specific port on the server and requests that the server respond to the client over a short-lived TCP or UDP port. The default range of short-lived ports used by client applications is 1025 through 5000. Under certain conditions, it is possible that the available ports in the default range are exhausted. 2 - If you are using any custom assembly method in any of your report (say for example PrivateFontCollection class or anything else), if yes then you might want to review that 3 - Change MaxActiveReqForOneUser from its default value o...
Read more

First hit to Reporting services is slow

Problem: First hit to Reporting services is slow Proposed Explanation and solution: This is because IIS is a demand-driven web server, i.e. IIS does things only when asked for. For example: an IIS worker process spawns up only when requests arrive for the sites that are hosted in this worker process. So when someone hit the reporting service for first time then it will perform some of the initialization activities such as: Initialization of data structures Loading data from a datastore into memory  (caching) Compilation of code, e.g. .NET applications Establishing database connections Recommendations: 1 – Spinning up an app pool can take some time and make the application less responsive so keeping them up for longer can help performance, so may be changing default recycle time from 720 min (12 hours) to 2880 min (48 hours) will help the performance 2 – Create and run simple scheduled report to keep SSRS active running every hour. For example: A simple ...
Read more