Tag: command line execute sql
-
How to execute sql file via command line for PostgreSQL
Use psql psql -U username -d myDataBase -a -f myInsertFile More information: http://blog.manoharbhattarai.com.np/2013/04/03/execute-sql-file-from-command-line-in-postgresql/
-
How to execute sql file via command line for Oracle
Use sql*plus run SQL file sqlplus username/password@databasename @/path/to/test.sql If you want to see whats going on like this, including any error messages, you need connect to SQL*Plus with sqlplus username/password@databasename Then run the script from the SQL*Plus prompt: set echo on @/path/to/test.sql
-
How to execute sql file via command line for DB2
You can save a .sql file to your hard drive, and execute it using the DB2 command line using: db2 -vtf C:\path\to\test.sql -v echoes the command text back to the command line -t sets the statement terminator to ;. -f tells the command line to load the commands from the file. See other command line options, http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010410.html. from: http://stackoverflow.com/questions/17834343/how-to-create-batch-file-to-execute-multiple-db2-queries
-
How to execute sql file at SQL Server command line
You can use sqlcmd to run a Transact-SQL script file. A Transact-SQL script file is a text file that can contain a combination of Transact-SQL statements, sqlcmdcommands, and scripting variables. To run the script file 1.Open a command prompt window. 2.In the Command Prompt window, type: sqlcmd -S myServer\instanceName -i C:\myScript.sql 3.Press ENTER. More information, see http://technet.microsoft.com/en-us/library/ms170572.aspx
-
How to execute sql file at MySQL command line
If you’re at the MySQL command line mysql> you can declare the SQL file as source, like: mysql> source ‘path/to/test.sql’; Or use the MySQL command line client: mysql -hhostname -uuser database < path/to/test.sql