How can you determine the version of a stored procedure using command line?

• 
  Hi @pporter,
  
  Can you give us a bit more detail about what you mean by "version of a stored procedure". Would you be interested in knowing which revision/commit is on the target server? Or are you just interested in checking the differences between what you have in source control and the target server?
  
  Thanks,
  
  Diogo

  Diogo June 22, 2018 14:54

  - 0 +
• 
  @Diogo, Thanks for your response.
  I would be interested in checking the differences between what we have in source control and the target server.

  pporter June 22, 2018 14:59

  - 0 +
• 
  Hi @pporter
  
  I think you can use the SQL Compare command line then. There is some documentation on this page http://https//documentation.red-gate.com/sc13/using-the-command-line
  
  I think you may want something like
  
  sqlcompare.exe /scr1:YourScriptsFolder /s2:YourDatabaseServer /db2:YourDatabaseName /u2:YourUsernameToConnectToTheDatabase /p2:YourPasswordToConnectToTheDatabase /Include:storedprocedure:\[YourStoredProcedureName\] /verbose
  

  Diogo June 22, 2018 15:17

  - 0 +
• 
  @Diogo, thanks again. This looks like the real deal, but I have one question: What, in this scenario, is the /scr1 folder switch used for? is this my repository folder on the source server? It doesn't explain it well (to my mind, at least) in the docs.
  Thanks in advance

  pporter June 26, 2018 10:25

  - 0 +
• 
  Hi @pporter .
  
  /scr1 is your local checkout of the repository.

  Diogo June 26, 2018 10:42

  - 0 +
• 
  thats kind of what i thought, but I keep getting a "Error: Invalid connection database connection parameter: "URI formats are not supported.

  Invalid connection database connection parameter: URI formats are not supported."
  
  

  my command line look like this:
  sqlcompare.exe /scr1:http://al-tfs:8080/tfs/afg /s2:GDC-DEV-1\SQLEXPRESS /db2:AFGWMS /u2:username /p2:password /Include:storedprocedure:Abattoir.HouseTagReserve_Select /verbose
  

  pporter June 26, 2018 11:19

  - 0 +
• 
  NVM, i get it..."Local"

  pporter June 26, 2018 11:30

  - 0 +

Add comment

Please sign in to leave a comment.