You are tasked with installing the Knowledge Center Database using the scripts that are stored on
the G drive. Your company currently uses SQL Server 2008.
What are the commands used to build the database using the scripts?
A.
Sqlcmd – I –S“mysqlserver” – i ” G:\Setup\db
scripts\MSSQL\knowledgwCenter\createDBObjects.sql “ – n DBOwner =” KUser
password = “password” – v DBName = “KMASTER” – v DBPath = “C: \ database”
B.
Sqlcmd – E – S“mysqlserver” – i ” G:\Setup\db
scripts\MSSQL\knowledgwCenter\createDBObjects.sql “ – n DBOwner =” KUser
password = “password” – v DBName = “KMASTER” – v DBPath = “C: \ database”
C.
Sqlcmd – E – s “mysqlserver” – e ” G:\Setup\db
scripts\MSSQL\knowledgwCenter\createDBObjects.sql “ – n DBOwner =” KUser
password = “password” – v DBName = “KMASTER” – v DBPath = “C: \ database”
D.
Sqlplus – s system/password@xe @ “E:\Setup\db
scripts\ORACLE\KnowledgeCenter\CreatesSchememaObjects.sql.sql” KUser password KMaster
“C: \ app \ oradata \ orcl \ KMaster.DBF” KMaster_TEMP
“C: \app\oradata \ orcl \ KMaster_TMP.DBF”
Explanation:
Use Sqlcmd – E – S“mysqlserver” – ietc.
To create the database using the CreateDB.sql script, enter the following at the command prompt:
sqlcmd – The command line application for the Microsoft Sequel server.
-E – Use a trusted connection to the Microsoft Sequel server. To use a login and password, use
the -U <LOGINID> -P <password> parameters.
-S <servername> – The name of the Microsoft SQL server.
-i “<scriptfile>” – The path to the script file and the name of the script file.
-v DBName=”<database name>” – The name of the database to be created.
-v DBPath=”<database file location”> – The path to the location where you want to create the
database.
Statement with generic parameters:sqlcmd -E -S <servername> -i <scriptfile> -v DBName=”<VALUE1>” -v DBPath=”<Value2>”
Example with default install parameters:
sqlcmd -E -S “mysqlserver” -i “CreateDB.sql” -v DBName=”KMASTER” -v DBPath=”C:\database”