call multiple .sql files through single Batch file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » call multiple .sql files through single Batch...

call multiple .sql files through single Batch file

Rate Topic

Display Mode

Topic Options

Author

Message

challa.narasaiah

Posted Thursday, December 13, 2012 8:25 PM

Forum 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

e4d4

Posted Friday, December 14, 2012 2:37 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:05 PM
Points: 150, Visits: 1,022

.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 »

Permissions