April 11, 2012 at 5:35 am
Hey guys
With every internal application release we have bunch SQL scripts which are checked into VSTS to execute in mutliple databases (which are on same build) in the following order.
Schema File
DDL File (only for Functions, Views, Reports)
DML File
Is there any way to execute these scripts as an exe file which is available by passing the paths for the files with execution order.
I have looked at SQL Packager from SQL Red Gate - wanted to know if there are other options/tools available.
Any suggestions/inputs will be helpful.
Thanks
April 11, 2012 at 6:12 am
SQL Packager is an option, but you could just build a batch command using SQLCMD.EXE. It won't be an executable, but a batch file will work the same way. Another option is to look to Visual Studio and create DACPAC files for deployment.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2012 at 6:13 am
Quest had a tool called change manager at one point, unsure if its still around or been replaced with something else.
other than that, you could create a custom bat file, which executes a big script, so concatinate all files into 1 big file, then use a batch file to execute sqlcmd from the command prompt and run it into the DB.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply