Use Oracle Developer Tools for Visual Studio

Oracle Developer Tools for Visual Studio is a tightly integrated extension for Microsoft Visual Studio and Oracle Autonomous Database. The extension is free and supports Visual Studio 2019 and Visual Studio 2017 on Microsoft Windows.

You can use the extension to perform database management operations right from Visual Studio, such as creating Autonomous Databases, stopping and starting, scaling up and down, and so on. You can also use the extension to easily connect to the databases and perform development tasks, such as browsing your Oracle schema and launching integrated Oracle designers and wizards to create and alter schema objects.

Users with permissions to manage the databases can perform a number of actions, including the following:

• Sign up for Oracle Cloud

• Connect to a cloud account using a simple auto-generated config file and key file

• Create new or clone existing Always Free Autonomous Database, Autonomous Database Dedicated, and Autonomous Database Serverless databases

• Automatically download credentials files (including wallets) and quickly connect, browse, and operate on Autonomous Database schemas

• Change compartments and regions without reconnecting

• Start, stop, or terminate Autonomous Database

• Scale up/down Autonomous Database resources

• Restore from backup

• Update instance credentials, update the license type used

• Rotate wallets

• Convert Always Free Autonomous Database into paid databases

  Note:

  Promotion of Always Free to paid is supported only if the Always Free instance has database release 19c.

Download the extension from Visual Studio Marketplace:

• Oracle Developer Tools for Visual Studio 2019

• Oracle Developer Tools for Visual Studio 2017

You'll find lots of information about the extension on those Marketplace pages.

Then follow the installation instructions and details about how to get started in this step-by-step walkthrough:

New Release: Visual Studio Integration with Oracle Autonomous Database

For detailed information about how to use the extension, see the online documentation that's optionally installed with Oracle Developer Tools for Visual Studio. Press the F1 key to display the context-sensitive help for each dialog.