Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

call multiple .sql files through single Batch file Expand / Collapse
Author
Message
Posted Thursday, December 13, 2012 8:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 14, 2012 5:08 AM
Points: 1, Visits: 2
In my sqlserver project so many .sql files in different folders Like

C:\username\EtlcontrolDB\scrip1.sql.........script10.sql C:\username\configuration\scrip1.sql.........script10.sql C:\username\Think...........................

My client requirement is , above folders contained sql files execution through single batch script. and sql filenames and filepath input geting from .txt file and also C:\username this one will be different for each user,remains path is similor to all users, also i want to execute some folders fully and some folders specific sql files only

Please any one share ideas about this requirement..... Thaks for advance...
Post #1396461
Posted Friday, December 14, 2012 2:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 12:47 PM
Points: 223, Visits: 1,724
.CMD files with for loops and execute sql script by using sqlcmd, or more current and more powerfull PowerShell.
Post #1396532
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse