![]() In the Object Migration dialog, verify that the migration script is correct and click OK.Ī migration script is code that changes the entire database or a part of it. The Migration dialog displays a migration script for the object. When you click the Submit button ( ) in the Database Changes tool window, you see the Migration dialog. (Optional) In the Database Changes tool window ( View | Tool Windows | Database Changes), double-click the modified object to open a difference viewer and verify your changes. Right-click an object and select Navigation | Go to DDL. The IDE will generate a migration script with your changes, prompt you to verify it, and then execute it in the database. You can update the source code of database objects by directly editing their DDL CREATE scripts and submitting your changes in the editor. You can select between the following options:Įxcept System Schemas: download source code for all the objects except for system schemas.Īll Schemas: download all the available source code. Right-click the selection and navigate to Load Sources. Select one or more data sources for which you want to download source code. In the Database tool window ( View | Tool Windows | Database), click the Data Source Properties icon. You can open data source properties by using one of the following options: You can manage this process in the data source properties. JetBrains Rider retrieves the source code for a data source during the introspection. The Database Changes tool window displays a summary of all your changes. The IDE will generate a migration script and execute it in the database. You can update the source code of database objects directly by editing their DDL and submitting your changes. ![]() This information is used to show the objects in the Database tool window, display their DDL, suggest them during completion, and in other features for coding assistance. ![]() JetBrains Rider retrieves the information about a database during the introspection process. Every modification that you make to these objects in the editor is saved as a local version of the object source code. These objects might be triggers, procedures, functions, views, or other objects. JetBrains Rider tracks changes that you make to objects that store their source code in the database. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name. Press Control+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 JetBrains Rider by default.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |