Skip to main content
V
VladiSlav17-Peridot
17-Peridot
October 16, 2019
Question

SqlServer commands

  • October 16, 2019
  • 2 replies
  • 5017 views

Hello everyone, how to execute sqlplus <db_user>/<db_user_pw>@<sid> command . If there is no Oracle, and there is SqlServer?
And what is @<sid> ?

2 replies

B
23-Emerald III
BenLoosli23-Emerald III
23-Emerald III
October 16, 2019

db_user is the name of the WIndchill user who executes DB commands. Found in db.properties file under the load point.

db_pass is the password for the db_user account. it is encrypted, so you have to know it or find someone who does.

sid is the name of the database defined when the system was created. It cam also be found in db.properties, if you know the service name.

 

Once SQLplus is open, you can execute your SQL scripts and logged into the DB, you8 can run the scripts or enter commands line by line.

 

 

 

    V
    VladiSlav17-PeridotAuthor
    17-Peridot
    October 17, 2019

    Thanks, , there is still a problem with sqlplus, how to change the command for SQLSERVER?

    db.JPG

    B
    BrianToussaint19-Tanzanite
    19-Tanzanite
    October 17, 2019

    It is showing that sqlplus isn't a recognized command, meaning that it isn't installed, not that the syntax of the command is wrong.  The question is why are you trying to use sqlplus via command line and not using SQL Server Management Studio?

    V
    VladiSlav17-PeridotAuthor
    17-Peridot
    February 12, 2020

    Hello, there is a video of training for example from the documentation

    https://www.youtube.com/watch?v=-14BSAwteVw&list=PLjm4gmbLQwoeqQSP7xUhCnInGknqTBAZV&index=2

    Terms & ConditionsAccessibility statement