Tag: deployment
-
Batch Script to Deploy Multiple SQL files (Version 2)
I took very long break to keep the site up to date with my learning. Few years back I wrote an article to deploy multiple scripts using batch files. Refer https://sql-articles.com/scripts/batch-script-to-deploy-multiple-sql-files/ for the older version in command prompt. Thanks for all the users and lot of comments for improvements.
-
SSIS 2014 Execution Error while validating Script Component
It’s been so long after my last article. Looks like I been lazy for few years now 🙂 I assume lot of people using  SSIS package deployment utility after they support project deployment model. I always use the ispac for easier deployment though it doesn’t support environments variables in deployment. Today we deployed a project to our environment…
-
Batch script to deploy multiple SQL files
I was working on a project where I’m supposed to deploy lots of SQL Server script files (.sql). It’s very tedious job either to manually execute or to write a batch script each time when the deployment moves to another environment. So I decided to write a batch script which should be dynamic in nature…
-
DAC – Data Tier Applications
This is one of the new feature released with SQL Server 2008 R2. I know it’s late to cover this topic. It has greater flexibility and easy of implementation for database perspective. I could say it’s a build which has all database & instance level objects for implementation, just run the build and get the…