Many Sql scripts to execute

[waqar100]

I have 90 scripts in C:\SQL Scripts\*sql

how could i execute by command ,i saw many things on net but could execute it successfully,,,
I am using sql 2008 R2 , not a default instance

[Rabbit]

You can run this from the command line:

for %f in (*.sql) do sqlcmd /S <servername> /d <dbname> /E /i "%f"

[waqar100]

I installed SQL multiScripts software ,, trial version

[NeoPa]

@Rabbit
Does your SQLCMD command cover the fact that the SQL Server is not running as the default instance?

@Waqar100
If you ask for assistance you should respond to when someone posts that help. If you have chosen to use special software to handle this in spite of standard software being available, and help for that given to you, surely you can explain why. Otherwise it seems like you have just ignored the expert whom you asked to help you.

[Rabbit]

@NeoPa, oh, I'm not sure. If it doesn't there's probably a switch for it.

[NeoPa]

Rabbit:
If it doesn't there's probably a switch for it.

That's cheating! :-D

OK. I looked it up myself (Connect to the Database Engine With sqlcmd). The syntax would be :

for %f in (*.sql) do sqlcmd /S <servername>\<instancename> /d <dbname> /E /i "%f"

[waqar100]

I am using this command,this will halt at.

for %f in (*.sql) do sqlcmd /S <WAQAR-PC>\<KARACHI20882>/d <SF_CORE_DEV_CMD> /E /i "%f"

See the image
http://postimg.org/image/6g76k7lax/
Now what should i do?

[NeoPa]

<servername>\<instancename> = WAQAR-PC\KARACHI20882 and there is a space before the /d.

Try that and let us know how you get on.

[waqar100]

Thanks Neo Pa
Now i am stucking at this stage , what should i do the next.
http://postimg.org/image/l4k0bv6hl/

FYI: i have temporary i am testing on only 3 files a t this location
say 3 scripts in c folder

Path=C:\FOlder and they are respectively 1.sql, 2.sql and 3.sql.

[Rabbit]

Please attach the image to the thread itself.

[waqar100]

which image @Rabbit? I didnt understand.

[Rabbit]

You attached an link to an image. Our firewalls block external file storage sites.

[waqar100]

Thanks Neo Pa
Now i am stucking at this stage , what should i do the next.
http://postimg.org/image/l4k0bv6hl/

FYI: i have temporary i am testing on only 3 files a t this location
say 3 scripts in c folder

Path=C:\FOlder and they are respectively 1.sql, 2.sql and 3.sql.



Now the link of above image is



Now it is ok?

[Rabbit]

That's too small to read. But it looks like a command prompt. So just type in the thread itself what the command prompt is showing.

[waqar100]

There are 2 snaps I attached of the different extension.if you are able to see then tell me the next steps.3 sql files are in C,, see the previous detail of this path.

[Rabbit]

It's too small for me to read. It's just command prompts, there's no need for screenshots, just type what it says in the thread.

[waqar100]

I typed already,& the issue is at the image,

[Rabbit]

I already said I can't read the text in the image. Type the text in the image into the thread itself.

[Oralloy]

Waqar100,

remove the "<" and ">" from your command.

It should probably read:

1.for %f in (*.sql) do sqlcmd /S WAQAR-PC\KARACHI20882 /d SF_CORE_DEV_CMD /E /i "%f"

[nbiswas]

c:\>for %f in (*.sql) do sqlcmd /S <servername> /d <dbname> /E /i "%f"