This action creates a temporary run configuration. Right-click the selection and invoke Run (or press Ctrl+Shift+F10). In the Project tool window ( View | Tool Windows | Project), select file or files that you want to run. Select the settings for your run configuration. To run the configuration right away, click Run. You can either run the configuration right away, or save the configuration to run it later.Ĭlick OK to save the run configuration for later and close the dialog. If a script contains schema switching, you will see a warning ( ). To add files, click the Add button ( ) and navigate to files that you want to run. Script files: SQL files that you want to run. If you select a data source as a target, PhpStorm displays a schema in which the script will be run. Target data source / schema: databases or schemas against which you want to run your database scripts. The fields that appear in the right-hand pane display the settings for the selected configuration type.

To edit an existing run configuration, expand the Database Script node and select the run configuration that you want to edit from the list. To create a new run configuration, click the Add New Configuration icon ( ) and select Database Script. In the Run/Debug Configurations dialog, you can either create a new run configuration or edit an existing one. With the Navigation bar visible ( View | Appearance | Navigation Bar), choose Edit Configurations from the run/debug configuration selector. Select Run | Edit Configurations from the main menu. Open the Run/Debug Configuration dialog in one of the following ways: In PhpStorm, the maximum number of DML statements that you can run from an SQL file is 1000. Depending on your purposes, you can run SQL files using one of the following ways:Ĭreate new run configurations or edit the existing ones via a run configuration widget.Ĭreate new run configurations via Project tool window by running the selected file.Ĭreate new run configurations via Database tool window by running a file against the selected database or schema. SQL files are run against the selected databases or schemas using run configurations. For more information about running applications and other files, refer to Run applications. This page describes how to run SQL files using the Database Tools and SQL plugin. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name. Press Ctrl+Alt+S to open the IDE settings and then select Plugins. If the relevant features aren't available, make sure that you didn't disable the plugin. This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in PhpStorm by default. Run SQL files Enable the Database Tools and SQL plugin

Phpstorm remote development ssh