Muokkaa

Jaa


Manage packages in database with Machine Learning extension for Azure Data Studio (Preview)

Learn how to manage Python or R packages in your database with the Machine Learning extension for Azure Data Studio.

Important

Manage packages in database with the Machine Learning extension currently only supports Machine Learning Services on SQL Server 2019.

Prerequisites

Manage Python packages

You can install and uninstall Python packages with the Machine Learning extension.

Install new Python package

Follow the steps below to install Python packages in your database.

  1. Select Manage packages in database.

  2. If you're asked to install sqlmlutils, select Yes.

  3. Under the Installed tab, select Python under the Package Type and select your database under Location.

  4. Select the Add new tab.

  5. Enter the Python package you like to install in Search Python packages and select Search.

  6. Verify the package is listed under Package Name and the desired version is listed under Package Version.

  7. Select Install.

  8. Select Close and verify that the package was installed successfully under Tasks.

Uninstall a Python package

Follow the steps below to uninstall Python packages in your database.

Note

You can only uninstall packages that have been installed in your database. It is not possible to uninstall a package that has been pre-installed with SQL Server Machine Learning Services.

  1. Select Manage packages in database.

  2. If you're asked to install sqlmlutils, select Yes.

  3. Under the Installed tab, select Python under the Package Type and select your database under Location.

  4. Select the package(s) you would like to uninstall.

  5. Select Uninstall selected packages.

  6. Select Close and verify that the package was installed successfully under Tasks.

Manage R packages

You can install and uninstall R packages with the Machine Learning extension.

Install new R package

Follow the steps below to install Python packages in your database.

  1. Select Manage packages in database.

  2. If asked to install sqlmlutils, select Yes.

  3. Under the Installed tab, select R under the Package Type and select your database under Location.

  4. Select the Add new tab.

  5. Enter the R package you like to install in Search R packages and select Search.

  6. Verify the package is listed under Package Name and the desired version is listed under Package Version.

  7. Select Install.

  8. Select Close and verify that the package was installed successfully under Tasks.

Uninstall an R package

Follow the steps below to uninstall R packages in your database.

Note

You can only uninstall packages that have been installed in your database. It is not possible to uninstall a package that has been pre-installed with SQL Server Machine Learning Services.

  1. Select Manage packages in database.

  2. If asked to install sqlmlutils, select Yes.

  3. Under the Installed tab, select R under the Package Type and select your database under Location.

  4. Select the package(s) you would like to uninstall.

  5. Select Uninstall selected packages.

  6. Select Close and verify that the package was installed successfully under Tasks.

Next steps