how to run a .sql script from a .bat file with out writing a dbname inside

• rajemessage 14195

  Hall of Fame

  Points: 3315

  More actions

  August 17, 2022 at 12:03 pm

  Go to Answer

  #4077354

  hi,

  this is how i call my files

  sqlcmd -S LA -U sa -P ppp  -i "D:\r1.sql"

  but i want to call like following ( like i call stored procedure)

  sqlcmd -S LA -U sa -P ppp  -Q "use srdb EXEC abc

  q1) in first way i have to write database name in r1.sql on each server.

  where as in second way use databse is written in .bat file i need that kind of calling , and for that i have to convert all my scripts like r1.sql to stored procedure , so pls tell me is there any way that i can call r1.sql with out putting databse name inside on diffrent server.

  yours sincerely

   

   

   

   

• Ant-Green

  SSC Guru

  Points: 113509

  More actions

  August 17, 2022 at 12:33 pm

  Answer

  #4077380

  You can use the -d switch and pass it a database name on the SQLCMD call, which will automatically issue a use command as part of the connection.

   

  sqlcmd -S LA -U sa -P ppp -d MyDB -i "D:\r1.sql"