Post reply

Executing .sql scripts file from command prompt

  • December 27, 2010 at 8:31 pm

    #244807

    I had created the .sql scripts for

    --Create Database

    --Create tables

    --Create Stored procedure

    I am using SQL server 2008.

    Now i want to deploy it into the target server using the command prompt.

    How can I call to execute that script on the target server?

  • December 27, 2010 at 9:17 pm

    #1266608

    exec master.dbo.xp_cmdshell 'osql -E -Sserver1 -i c:\temp\<filename>.sql'

    Make sure the following too:

    EXEC sp_configure 'xp_cmdshell', 1

    RECONFIGURE

    GO

  • December 28, 2010 at 5:05 am

    #1266683

    I wanna create a .cmd file and have to make it simple so non technical person can do it from command line using the installation instructions.

  • December 28, 2010 at 5:10 am

    #1266684

    Its a command line execution method only.

    Create a batch file.

    Place the statements correctly with correct server name.

    Place Go in between the commands.

    If am not answering your question, write in again.

  • December 28, 2010 at 8:22 am

    #1266754

    Hi,

    I created the .bat file but i need something like ...

    If any one click on the batch file ,then i want that it ask for the server name and then that perticular scripts run on that server.

    I don't wanna use the server name in the .bat file.

    I will appriciate your help.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply